on 01-07-2012 5:35 AM
how can i revoke ADMINISTER RESOURCE MANAGER privilege.
this privilege contains a user.
SQL> revoke ADMINISTER RESOURCE MANAGER to test;
revoke ADMINISTER RESOURCE MANAGER to test
*
ERROR at line 1:
ORA-00990: missing or invalid privilege
Regards,
manage own way.
BEGIN
DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SYSTEM_PRIVILEGE(
GRANTEE_NAME => 'TEST',
PRIVILEGE_NAME => 'ADMINISTER_RESOURCE_MANAGER',
ADMIN_OPTION => FALSE);
END;
/
BEGIN
DBMS_RESOURCE_MANAGER_PRIVS.REVOKE_SYSTEM_PRIVILEGE ('TEST');
END;
/
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.