Database Security Products (MOSC)

MOSC Banner

enable Audit for all the users as ADMINISTER RESOURCE MANAGER

edited May 13, 2012 11:31PM in Database Security Products (MOSC) 2 comments
hi,
please help me on enabling audit on ADMINISTER RESOURCE MANAGER.
I am successfully enabled audit for aparticular user using the below procedure.
 BEGIN
DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SYSTEM_PRIVILEGE('SURESH_DBA',
      PRIVILEGE_NAME => 'ADMINISTER_RESOURCE_MANAGER',
   ADMIN_OPTION   => FALSE);
END;
but how I need to enable generically.
like I need to enable it for all users .
Example:
==================
lbelow audit will applicable to all the users
audit ALTER ANY INDEXTYPE by access;
this will enable for all the users.
====================
Please help me to fix this.
Regards,
Naresh
DBA

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center