| Grant restriction [message #310429] |
Tue, 01 April 2008 04:38  |
Buchas
Messages: 101
Registered: March 2006
|
Senior 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  |
 |
Michel Cadot
Messages: 68634
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
