OraFAQ Forum: Server Administration » Hide a table from everyone

Home » RDBMS Server » Server Administration » Hide a table from everyone

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

Hide a table from everyone [message #174942]

Wed, 31 May 2006 02:08

papu
Messages: 27
Registered: March 2005
Location: Dhaka

Junior Member

hello all

i have a table & I would like to hide the table from others even the DBA, so that it is only visible to me. is this possible in Oracle

Thanx in advance.

regards

papu

Report message to a moderator

Re: Hide a table from everyone [message #174944 is a reply to message #174942]

Wed, 31 May 2006 02:18

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

You can hide the contents. Not the table.
Look into VPD (virtual Private database)/FGA(fine grained access)
>>from others even the DBA
Depends on how the DBA is defined here.
With SYS access, one can easily override your settings.

Report message to a moderator

Re: Hide a table from everyone [message #174945 is a reply to message #174942]

Wed, 31 May 2006 02:18

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

In normal circumstances, you don't even have to hide it from other users; unless you give them access to it, they won't even know it exists.

From the DBA? I think it isn't possible (unless you DROP the table).

Report message to a moderator

Re: Hide a table from everyone [message #175049 is a reply to message #174942]

Wed, 31 May 2006 09:22

papu
Messages: 27
Registered: March 2005
Location: Dhaka

Junior Member

how can i hide the contents of a table.

plz provide an example on emp table

regards

papu

Report message to a moderator

Re: Hide a table from everyone [message #175054 is a reply to message #175049]

Wed, 31 May 2006 09:34

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

As Littlefoot has already stated,
A DBA with Full privileges can easily Override whatever you do.

This article is little outdated, but the concept still holds good.
You may want to check with the newer versions.
http://www.oracle-base.com/articles/8i/VirtualPrivateDatabases.php

Report message to a moderator

Previous Topic:	Error 00439
Next Topic:	Database slow down

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 20 14:02:45 CST 2025