Home » RDBMS Server » Security » User Privilege
User Privilege [message #315263] Sun, 20 April 2008 10:13 Go to next message
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

Hello everyone

I have got a question regarding privileges in oracle database.

In oracle one can give privileges to a user on a single table

but what if one wants to give privileges for a whole schema to a user ?
Re: User Privilege [message #315264 is a reply to message #315263] Sun, 20 April 2008 10:34 Go to previous messageGo to next message
Michel Cadot
Messages: 65152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This does not exist.
There are:
- system privilege
- object privilege

Object privileges are on 1 object.

Re: User Privilege [message #315286 is a reply to message #315264] Sun, 20 April 2008 15:52 Go to previous message
Messages: 21148
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
In other words, if there are hundreds of objects in someone's schema, you'll have to use hundreds of GRANT statements to grant these privileges.

There's, however, no need to type all of them manually - write SQL which will generate such an SQL for you (SPOOL command and USER_OBJECTS view might be handy in this operation).
Previous Topic: insufficient privelege
Next Topic: scott /tiger cant see system tables/cant create another user
Goto Forum:

Current Time: Tue Aug 22 06:20:42 CDT 2017

Total time taken to generate the page: 0.05786 seconds