| to GRANT Privilege [message #235280] |
Fri, 04 May 2007 12:26  |
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
|
Senior Member |
|
|
hi from my user,i created another user but i am not able to grant resource,create session to that user.it says
ORA-01031: insufficient privileges
wht privilege should i have
|
|
|
|
| Re: to GRANT Privilege [message #235281 is a reply to message #235280] |
Fri, 04 May 2007 12:47  |
 |
Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
1/ Never grant resource to a user.
It is obsolete.
It is safeless.
Create your own role with accurate privileges and grant it.
2/ To be able to grant a privilege/role you must either:
- have this privilege/role with admin option
- have grant any privilege/grant any role privilege
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
