Home » RDBMS Server » Security » Grant restriction (Oracle 9)
Grant restriction [message #310429] Tue, 01 April 2008 04:38 Go to next message
Buchas
Messages: 81
Registered: March 2006
Member
Hello,

I would like to create the Oracle user TEST, whose tables would be accessible only to TEST. Other users (including SYSTEM, SYS) should not be able to access tables of TEST user, even if using

GRANT SELECT ON TEST.TEST_TABLE_T TO SYSTEM;


I would like the human to enter password of TEST for accessing its tables. Is it possible to do that?
Re: Grant restriction [message #310477 is a reply to message #310429] Tue, 01 April 2008 07:06 Go to previous message
Michel Cadot
Messages: 59427
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't remove access from DBA or SYSDBA.
You have to use Database Vault for this.

Regards
Michel
Previous Topic: change system password
Next Topic: Database security
Goto Forum:
  


Current Time: Fri Oct 24 23:23:18 CDT 2014

Total time taken to generate the page: 0.08859 seconds