Home » RDBMS Server » Security » alter user admin option
alter user admin option [message #205952] Tue, 28 November 2006 03:55 Go to next message
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


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.

Re: alter user admin option [message #205959 is a reply to message #205952] Tue, 28 November 2006 04:02 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
SQL> GRANT select_catalog_role TO scott WITH ADMIN OPTION;

Grant succeeded.
Re: alter user admin option [message #205964 is a reply to message #205959] Tue, 28 November 2006 04:12 Go to previous messageGo to next message
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 =)
Re: alter user admin option [message #205973 is a reply to message #205964] Tue, 28 November 2006 04:38 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
You can just regrant it.
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:
  


Current Time: Thu Mar 28 13:19:56 CDT 2024