Home » RDBMS Server » Security » to GRANT Privilege
to GRANT Privilege [message #235280] Fri, 04 May 2007 12:26 Go to next message
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 Go to previous message
Michel Cadot
Messages: 68045
Registered: March 2007
Location: Nanterre, France, http://...
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

Previous Topic: Virtual Private Database
Next Topic: how to know who disable a trigger
Goto Forum:

Current Time: Mon Dec 06 00:28:07 CST 2021