user privilege bug: grant causes error ORA-00990: "missing or invalid privilege"

Bernhard S

Member³
When a user has the privilege "administer resource manager" PSD creates the following grant when viewing or editing a user:
grant administer resource manager to ;

However when trying to execute this grant, you get the following error:
ORA-00990: "missing or invalid privilege"

This privilege cannot be granted like that. You need to use packaged procedure DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SYSTEM_PRIVILEGE instead.
See alsohttp://www.orafaq.com/forum/t/125442/0/
and read
Database Administrator's Guide
Chapter 24 Using the Database Resource Manager
Section Administering the Database Resource Manager

 
Back
Top