Home » SQL & PL/SQL » SQL & PL/SQL » Grant and Revoke commands
Grant and Revoke commands [message #267633] Fri, 14 September 2007 00:45 Go to next message
Messages: 16
Registered: April 2005
Location: MRU
Junior Member
Hi to all,

I want to grant or revoke all objects in a schema to a particular user..

For example to revoke an object from a user:

revoke all on schemaname.objectname from user

Now I want to revoke all objects in a schema from a user. How this is done.

Same applies from the GRANT command.

Re: Grant and Revoke commands [message #267634 is a reply to message #267633] Fri, 14 September 2007 00:52 Go to previous messageGo to next message
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
For Grant command read this
For Revoke command read this


[Updated on: Fri, 14 September 2007 00:54]

Report message to a moderator

Re: Grant and Revoke commands [message #267644 is a reply to message #267633] Fri, 14 September 2007 01:33 Go to previous message
Michel Cadot
Messages: 65090
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How this is done.

You have to repeat for each object.

Previous Topic: Data transfer (merged)
Next Topic: Problem with trigger
Goto Forum:

Current Time: Thu Jul 27 22:01:39 CDT 2017

Total time taken to generate the page: 0.13159 seconds