Home » RDBMS Server » Security » Oracle database vault query (Oracle database with Vault, Linux 6.4)
Oracle database vault query [message #598216] Fri, 11 October 2013 09:05
Messages: 2
Registered: October 2013
Location: UK
Junior Member

I have been asked to test if below scenario is possible in Database Vault

Scenario : I have a database called ORCL ( hosted on a server db1.abc.com having IP address I have a database user TEST which has a table say TBL_SENSITIVE_DATA, which hold sensitive data. I used Database Vault to protect this table from DBA etc.,
There are number of application servers say appserver1.abc.com (, appserver2.abc.com etc( which run JBoss applicaiton to the database server.

I'm using web browser to administer database vault from client machine say dbaclient.abc.com

My requirement :
1) Database connection to TEST user should be allowed ONLY from application servers ( & SQL*Pluse, SQL Developer tools etc should not be able to access from application servers.
2) SYS, SYSTEM, DBVOWNER, DBVACCTMGR users should be accessible from any client within the IP range from to The client can use SQL*PLUS, SQL Developer, toad etc tools to connect to the database and DBVOWNER uses URL to access Vault.

Is is possible to acheive this using Database Vault ONLY? If yes, how.

Previous Topic: DBMS_REDACT package not available in oracle 11g
Next Topic: Package body,triggers are not appearing on "Connect" user
Goto Forum:

Current Time: Mon Feb 06 07:04:33 CST 2023