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
svik
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.

Thanks
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
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
For Grant command read this
http://download.oracle.com/docs/cd/B14117_01/server.101/b10759/statements_9013.htm
For Revoke command read this

http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/statements_9020.htm

[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: 64110
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
How this is done.

You have to repeat for each object.

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


Current Time: Mon Dec 05 10:57:23 CST 2016

Total time taken to generate the page: 0.04753 seconds