OraFAQ Forum: Security » ORA-01932: ADMIN option not granted for role

Home » RDBMS Server » Security » ORA-01932: ADMIN option not granted for role (Oracle 11.1.0.7.0,Unix)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01932: ADMIN option not granted for role [message #520547]

Tue, 23 August 2011 06:43

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

Report message to a moderator

Re: ORA-01932: ADMIN option not granted for role [message #520550 is a reply to message #520547]

Tue, 23 August 2011 06:48

Michel Cadot
Messages: 68641
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

Report message to a moderator

Previous Topic:	oracle 10g security for developer
Next Topic:	AUDIT_TRAIL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 09:44:49 CDT 2024