| User Privilege [message #315263] |
Sun, 20 April 2008 10:13  |
balaji1482
Messages: 94
Registered: July 2007
Location: INDIA |
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  |
Michel Cadot
Messages: 15243
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
This does not exist.
There are:
- system privilege
- object privilege
Object privileges are on 1 object.
Regards
Michel
|
|
|
| Re: User Privilege [message #315286 is a reply to message #315264 ] |
Sun, 20 April 2008 15:52 |
Littlefoot
Messages: 5640
Registered: June 2005
Location: Croatia, Europe |
Senior Member |
|
|
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).
|
|
|
]
Members
Search
Help
Register
Login
Home
