| 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
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 #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 =)
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
