Home » RDBMS Server » Security » object privilege
object privilege [message #30852] Wed, 26 May 2004 23:37 Go to next message
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 .
Re: object privilege [message #30871 is a reply to message #30852] Thu, 27 May 2004 08:17 Go to previous message
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.
Previous Topic: Connectivity: SQL*Net and Security
Next Topic: Password-reset track
Goto Forum:

Current Time: Wed Nov 30 07:12:52 CST 2022