OraFAQ Forum: Security » alter user admin option

Home » RDBMS Server » Security » alter user admin option

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

alter user admin option [message #205952]

Tue, 28 November 2006 03:55

ehegagoka
Messages: 493
Registered: July 2005

Senior Member

hi!,
i have a user which i have granted some privileges, when i use that user to grant also those priviledges with other user i get this error

Code: [Select all] [Show/ hide]

ORA-01932: ADMIN option not granted for role 'SELECT_CATALOG_ROLE'

how can i "upgrade" his rights to admin option?

thank you so much sir/mam.

Report message to a moderator

Re: alter user admin option [message #205959 is a reply to message #205952]

Tue, 28 November 2006 04:02

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

Code: [Select all] [Show/ hide]

SQL> GRANT select_catalog_role TO scott WITH ADMIN OPTION;

Grant succeeded.

Report message to a moderator

Re: alter user admin option [message #205964 is a reply to message #205959]

Tue, 28 November 2006 04:12

ehegagoka
Messages: 493
Registered: July 2005

Senior Member

hi!,
thanks sir, i've already grant it before but without the WITH ADMIN OPTION, do i need to execute the GRANT...command again? i mean revoke it first then re-GRANT it WITH ADMIN OPTION? or is there an ALTER USER...WITH ADMIN OPTION something like of command?

i did the GRANT again WITH ADMIN OPTION, it succeeded, is there any problem executing the same grant twice?

thank you so much again =)

Report message to a moderator

Re: alter user admin option [message #205973 is a reply to message #205964]

Tue, 28 November 2006 04:38

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

You can just regrant it.

Report message to a moderator

Previous Topic:	System Setup and Security
Next Topic:	Need to find the no. of users who have not logged into Oracle database since some period of time.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 10:30:06 CDT 2025