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

Report message to a moderator

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: 68675
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Sep 08 17:20:59 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.