Home » SQL & PL/SQL » SQL & PL/SQL » Grant - All objects in a schema to a new user
Grant - All objects in a schema to a new user [message #252303] Wed, 18 July 2007 09:44 Go to next message
prabhuapps
Messages: 79
Registered: June 2005
Location: Bangalore
Member
Hi,

I have 100 objects in a schema. I want to provide "Select Privilege" to user ABC.

Is it possible by a single command Instead giving for each and every object?

Regards,
Prabhu
Re: Grant - All objects in a schema to a new user [message #252318 is a reply to message #252303] Wed, 18 July 2007 10:56 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.

But you easily can generate a script to do that: dba_tables contains all table names.

Regards
Michel
Previous Topic: pl/sql
Next Topic: Drop objects
Goto Forum:
  


Current Time: Sun Dec 11 02:25:28 CST 2016

Total time taken to generate the page: 0.08413 seconds