OraFAQ Forum: Security » User Privilege

Home » RDBMS Server » Security » User Privilege

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

User Privilege [message #315263]

Sun, 20 April 2008 10:13

balaji1482
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 ?

Report message to a moderator

Re: User Privilege [message #315264 is a reply to message #315263]

Sun, 20 April 2008 10:34

Michel Cadot
Messages: 68420
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.

Regards
Michel

Report message to a moderator

Re: User Privilege [message #315286 is a reply to message #315264]

Sun, 20 April 2008 15:52

Littlefoot
Messages: 21760
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).

Report message to a moderator

Previous Topic:	privileage issue in V$session?
Next Topic:	forgot the password of a schema

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 29 08:36:54 CDT 2023