 Related Questions REDUCED GRANTING OF PRIVILEGES - Rather than explicitly granting the same set of privileges to many users a database administrator can grant the privileges 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. ... Statement Auditing, Privilege Auditing and Object Auditing. Statement auditing is the auditing of the powerful system privileges without regard to specifically named objects. Latest Answer : The Statement auditing is tracking the SQL statements issued by database users. In order to enable or disable auditing on SQL statements, you must have the AUDIT SYSTEM privilege. ... Privilege auditing is the auditing of the use of powerful system privileges without regard to specifically named objects. Latest Answer : Privilege auditing involves the tracking of the SQL statements issued by users who have been granted the right to execute that statement through a system privilege. In order to enable or disable auditing on SQL statements, you must have the AUDIT SYSTEM ... 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. ... 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 How will you enable database auditing? In How many ways can you implement database auditing? Latest Answer : There's another option.There is a product called OraPlayer, that is tracking all actions performed by all the end-users of Oracle Forms. It tracks all the data sent from the forms user to the server and from the server. ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
