REDUCED GRANTING OF PRIVILEGES - Rather than explicitly granting the same set of privileges to many users a database administrator can grant the privileges
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.
Installing and upgrading the Oracle Server and application tools.Allocating system storage and planning future storage requirements for the database system.Managing primary database structures
Latest Answer : adding to the list* involved in database design * applying patch sets * writing scripts to automate the routine DBA tasks* configuring oracle net such as listeners and tnsnames* data loading and unloading using exp/imp and sqlloader* providing help to ...
DBA - role Contains all database system privileges. SYS user account - The DBA role will be assigned to this account. All of the base tables and views for the database's
Latest Answer : &DBSNMPSupports Oracle SNMP (Simple Network Management Protocol). The Oracle Intelligent Agent requires a database logon for each SID that it manages. By default this account is called "DBSNMP" CheersRavi Prakashhttp://ravidba-oracle.blogspot.com/ ...
