Home » SQL & PL/SQL » SQL & PL/SQL » question regarding grants
question regarding grants [message #350359] Wed, 24 September 2008 17:20 Go to next message
ora1980
Messages: 251
Registered: May 2008
Senior Member
i have a schema, named A, thats my schema

i am trying to grant select on table btable in schema B , to
another schema C


grant select on B.btable to C
/




it says ORA - 01031 Insufficient privileges..

what privilege I (user A) need in order to do that?
Re: question regarding grants [message #350360 is a reply to message #350359] Wed, 24 September 2008 17:29 Go to previous message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
You nedd the select privilege, with grant option
Previous Topic: Query improvement (avoiding code duplication, etc)
Next Topic: error while adding column on table
Goto Forum:
  


Current Time: Mon Dec 05 15:13:07 CST 2016

Total time taken to generate the page: 0.10636 seconds