Statement Auditing, Privilege Auditing and Object Auditing in oracle

Define Statement Auditing, Privilege Auditing and Object Auditing in oracle.

- Statement auditing is the auditing of the powerful system privileges without regard to specifically named objects.

- Privilege auditing is the auditing of the use of powerful system privileges without regard to specifically named objects.

- Object auditing is the auditing of accesses to specific schema objects without regard to user.
How to retrieve 5th highest sal from emp table? - oracle
Retrieve 5th highest sal from emp table - SELECT DISTINCT (emp1.sal) FROM EMP emp1 WHERE &N = (SELECT COUNT (DISTINCT (emp2.sal))...
What is $FLEX$ and $PROFILES$? Where are they used? - oracle
What is $FLEX$ and $PROFILES$? - $FLEX$ is used to get a value used in the previous value set. It is usually used to retrieve the Flex value contained in an AOL value...
oracle-trigger-inside-procedure.aspx
Trigger inside a stored procedure - A trigger cannot be called within a stored procedure. Triggers are executed automatically as a result of DML or DDl commands...
Post your comment