Home » RDBMS Server » Security » ORA-01932: ADMIN option not granted for role (Oracle 11.1.0.7.0,Unix)
ORA-01932: ADMIN option not granted for role [message #520547] Tue, 23 August 2011 06:43 Go to next message
Smith14
Messages: 38
Registered: July 2011
Location: India
Member
Hi,


When i try to grant role to user , i get following error.


SQL>
SQL> GRANT MAINTAIN_TEO TO CEE_WIRELINE;
GRANT MAINTAIN_TEO TO CEE_WIRELINE
*
ERROR at line 1:
ORA-01932: ADMIN option not granted for role 'MAINTAIN_TEO'


SQL>


Can somebody advice how to fix this error?

Thanks
Re: ORA-01932: ADMIN option not granted for role [message #520550 is a reply to message #520547] Tue, 23 August 2011 06:48 Go to previous message
Michel Cadot
Messages: 66446
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As explained in SQL Reference GRANT prerequisites

Quote:
To grant a role, you must either have been granted the role with the ADMIN OPTION or have been granted the GRANT ANY ROLE system privilege, or you must have created the role.


Regards
Michel
Previous Topic: oracle 10g security for developer
Next Topic: AUDIT_TRAIL
Goto Forum:
  


Current Time: Mon Jun 24 23:11:17 CDT 2019