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
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
Messages: 2844
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: Thu Aug 17 08:52:39 CDT 2017

Total time taken to generate the page: 0.15375 seconds