 Related Questions Roles are named groups of related privileges that are granted to users or other roles. Latest Answer : Roles are named groups of privileges (which my OR MAY NOT be related to each other) that are granted to users or other roles. ... REDUCED GRANTING OF PRIVILEGES - Rather than explicitly granting the same set of privileges to many users a database administrator can grant the privileges The Tablespace to contain schema objects created without specifying a tablespace name. Latest Answer : The default tablespace is the tablepsace in which the user's objects are created. Generally while creating the user, the default tablespace is mentioned. If by any chance the default tablespace is not mentioned while creating the user, the default ... Each database user is assigned a Profile that specifies limitations on various system resources available to the user. Latest Answer : A profile is used to restrict the reource uses, password reuses, idle time of a session etc. We can also attach a password verify function for the database user. A database user can be assigned a profile. It is an optional clause. ... The number of concurrent sessions the user can establish the CPU processing time available to the user's session the CPU processing time available to a single call to ORACLE Latest Answer : Amount of CPU TIME, PERCENTAGE CPU, IDLE TIME etc.. ... Monitoring of user access to aid in the investigation of database use. Latest Answer : Auditing involves in recording all the activities based on the auditing rulesSome types of auditing are Database level Auditing, Schema Level auditing, Object level Auditing and Statement level auditing. ... Object auditing is the auditing of accesses to specific schema objects without regard to user. Latest Answer : Object auditing involves the tracking of the specific SQL DML statements issued against objects by database users. ... An user account is not a physical structure in Database but it is having important relationship to the objects in the database and will be having certain privileges. Don't grant user access directly to tables within the application. Instead grant the ability to access the procedures that access the tables. When procedure executed it will execute DBA_FREE_SPACEDBA_SEGMENTSDBA_DATA_FILES.
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
