cancel
Showing results for 
Search instead for 
Did you mean: 

how can i revoke ADMINISTER RESOURCE MANAGER privilege

Former Member
0 Kudos

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,

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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