Home » RDBMS Server » Security » How to hide not-owned tables from users?
How to hide not-owned tables from users? [message #134939] Mon, 29 August 2005 02:40 Go to next message
Achchan
Messages: 86
Registered: June 2005
Member
Hi all,
This may seems dummy but scenario is:
I have one schema called user1.I have created another user called user2 that I want to have select,insert,update,delete privileges on tables of user2.
Initially I granted only resource,connect to user2.Then I created and ran a script that grant select,insert,update,delete to user2.But When I query all_tables (connected by user2) I can see many more tables that are not in user_tables.
I tried to revoke access to those additional tables from PUBLIC but no chance.What should I do(revoke) to have same result from user_tables and all_tables?!
-Thanks in advance
PS: Also our .Net developers that use ODP.NET see many many more tables in list of tables.(They are connected with user2)
Re: How to hide not-owned tables from users? [message #134945 is a reply to message #134939] Mon, 29 August 2005 02:59 Go to previous message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
What should I do(revoke) to have same result from user_tables and all_tables?


User_tables list the tables owned by the user.
all_tables list the tables that are accessible to user i.e. those tables on which user is having access privilege.

Hope these two articels help:

http://www.techonthenet.com/oracle/grant_revoke.php
http://www.dba-oracle.com/art_builder_grant_sec.htm

Regds
Girish
Previous Topic: tool for mixing table data in a test database
Next Topic: so many users
Goto Forum:
  


Current Time: Fri Mar 29 05:33:45 CDT 2024