enable Audit for all the users as ADMINISTER RESOURCE MANAGER
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;
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
0