Home » SQL & PL/SQL » SQL & PL/SQL » How to hide tables in a schema?
How to hide tables in a schema? [message #382448] Thu, 22 January 2009 06:22 Go to next message
chandu_imax
Messages: 46
Registered: May 2008
Location: Hyderabad
Member
Hi,

I created a database user scott and i created some tables in that user(Schema). Now i want those tables to be hide.
Is there any concept like Hiding the table in oracle? If so please reply for this.

Thanking you..
Re: How to hide tables in a schema? [message #382451 is a reply to message #382448] Thu, 22 January 2009 06:31 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Schema owner sees all its objects; you can't hide anything from yourself.

However, you might create another user, grant certain privileges on these tables, create synonyms which newly created user might use and hide information you'd like to conceal.
Re: How to hide tables in a schema? [message #382464 is a reply to message #382448] Thu, 22 January 2009 07:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
To say in other words what Littlefoot said, objects (tables) are visible only to users that can access it (and so of course to its owner).
Note that if the creator is not the owner then it can lose the visibility of the table it created.

Regards
Michel
Re: How to hide tables in a schema? [message #382465 is a reply to message #382448] Thu, 22 January 2009 07:29 Go to previous message
averion
Messages: 42
Registered: January 2009
Location: US
Member
Yes, I think the only way to hide is to create a new user and grant limited previliges taking into consirderation synonyms.
Previous Topic: Sunday in Month
Next Topic: need help in PLSQL
Goto Forum:
  


Current Time: Fri Dec 09 05:55:09 CST 2016

Total time taken to generate the page: 0.09791 seconds