Is "ALTER user hue quota 100m on system;" mandatory when install Hue metadata on Oracle database?

Question

Hi,

I'm going to install Cloudera on a customer required Oracle for store CDH Metadata. System DBA asked me if the property

ALTER user hue quota 100m on system;

is mandatory and why.

Someone knows if I can skip safely this command?

Thanks in advance.

Roberto

GangWar · Accepted Answer

@roberto10

Apologies for typo errors in my previous post.
1. Hue also needs a quota on SYSTEM tablespace because so that can stored Non Hue user specific data in that tablespace.
2. Any Hue specific information that is stored in DB in table or some format could be assume as object.
3. If you don't give quota on SYSTEM tablespace it will broke at some point because it might store all info in one tablespace and after that will confuse to diffrentiate.
You might be intrested to read below document, it's very nice doc to understand the quota concept.
https://docs.oracle.com/database/121/DBSEG/users.htm#DBSEG573

GangWar · Answer

@roberto10Assigning a quota does two things:1. Users with privileges to create certain types of objects can create those objects in the specified tablespace.2. Oracle limits the amount of space that can be allocated for storage of a user's objects within the specified tablespace to the amount of the quota.By default, a user has no quota on any tablespace in the database. If the user has the privilege to create a schema object, you must assign a quota to allow the user to create objects. Minimally, assign users a quota for the default tablespace, and additional quotas for other tablespaces in which they can create objects.So every step in the document is recommended While cresting Hue database to run Hue smooth.https://www.cloudera.com/documentation/enterprise/latest/topics/hue_dbs_oracle_pkg.html#concept_t3s_bkp_zw

Sign up

Please use your Cloudera account.

Login to the community

Please use your Cloudera account.