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

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

Scenario : I have a database called ORCL (11.2.0.3) hosted on a server db1.abc.com having IP address 192.168.10.10. 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 (192.168.20.20), appserver2.abc.com etc(192.168.30.30) which run JBoss applicaiton to the database server.

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

My requirement :
1) Database connection to TEST user should be allowed ONLY from application servers (192.168.20.20 & 192.168.30.30). 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 150.150.15.0 to 150.150.15.255. 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: Thu Mar 28 12:28:49 CDT 2024