OraFAQ Forum: Security » object privilege

Home » RDBMS Server » Security » object privilege

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

object privilege [message #30852]

Wed, 26 May 2004 23:37

surendar
Messages: 3
Registered: February 2002

Junior Member

I have created a user and granted�� select on� some eight objects when I� see� the� all_tab_privs ,It� shows� more than� eight objects.

It includes� public� rights granted� for other objects also .But I don't� want� users� accessing any objects other than this eight .How� to� implement this ?

I don't� like to revoke select privs for other objects� granted to� public which will affect other existing� users.

Please reply me .

Thanks in advance .

Report message to a moderator

Re: object privilege [message #30871 is a reply to message #30852]

Thu, 27 May 2004 08:17

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

You will need to create a new role with the appropriate privileges and grant that role only to the users who should see those objects. PUBLIC means everyone - you cannot exclude someone from it.

Report message to a moderator

Previous Topic:	Connectivity: SQL*Net and Security
Next Topic:	Password-reset track

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 01 14:39:16 CDT 2025