Home » Other » Test » Database Vault query (Oracle 11gR2, Linux)
Database Vault query [message #598215] Fri, 11 October 2013 09:04
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.

Appreciate your replies.

Cheers,
Previous Topic: In tabular form, the fields will not fit in a canvas
Next Topic: editing test
Goto Forum:
  


Current Time: Fri Nov 28 14:35:15 CST 2014

Total time taken to generate the page: 0.13891 seconds