Monthly Archives: May 2008

java.lang.UnsatisfiedLinkError: no jmisc in java.library.path

When disabling & enabling database vault 11.0.6.0 on Sun Solaris $ dvca -action disable -service DEV -instance DEV -dbname DEV -sys_passwd spass -owner_account vowner -owner_passwd vpass Command throw “Exception in thread “main” java.lang.UnsatisfiedLinkError: no jmisc in java.library.path”. Solution is to … Continue reading

Posted in Oracle Security | Tagged | Leave a comment

Database upgrade from 10.2.0.3 to 10.2.0.4

Database – Oracle Enterprise Edition 10.2.0.3 Platform – Sun SPARC Solaris 10 64-bit I recently upgraded my Oracle RAC database to 10.2.0.4. Software upgrade worked fine. But after manually upgrading the database, Component ‘Oracle Database Server’ becomes INVALID Oracle Database … Continue reading

Posted in Oracle Database Upgrade | Tagged | 3 Comments

Enforcing row level security using Virtual Private Database (VPD)

Scenario In an organization, employees are categorised in three domain verticals. (a) Finance (b) Insurance (c) Healthcare (d) HR Every vertical have a HR lead. HR leads report to HR head. Problem statement (1) HR leads should only be able … Continue reading

Posted in Oracle Security | Tagged | Leave a comment

Speed-up Bulk Delete on Logical Standby

Problem statement: Bulk delete operation performed on the primary database in data guard environment, results in stale in logical standby. Set of delete statements executed on primary SQL> delete from TABA where id=100; 1000000 Rows deleted. SQL> delete from TABB … Continue reading

Posted in Oracle Data Guard, Oracle Logical Data Guard | Tagged | 2 Comments

Using Database Vault Secure Application Roles to restrict the data access from designated application

Problem statement: Users should be allowed the access to the data from the customized application. Solution: To achieve this we will create the secured application role and associate it with the rule set. This will allow the access to data … Continue reading

Posted in Oracle Database Vault, Oracle Security | Tagged | 2 Comments

Using Identities in Data Vault to Restrict User Activities

Problem statement: Users should only be allowed to login from SECURE INTERNAL network. Solution: to achieve this, we’ll be using the out-of-box DOMAIN factor. First create the user, to be used $sqlplus vowner SQL> create user testuser identified by password; … Continue reading

Posted in Oracle Database Vault, Oracle Security | Tagged | Leave a comment

Using FACTORS in Database Vault to restrict access

Problem Statement: User should be able to connect to database from a specific host Following is the list of pre-defined factors SQL> SELECT OBJECT_NAME, OBJECT_TYPE FROM DBA_OBJECTS WHERE OWNER=’DVF’ AND OBJECT_NAME LIKE ‘F$%’ / OBJECT_NAME OBJECT_TYPE —————————————————– F$AUTHENTICATION_METHOD FUNCTION F$CLIENT_IP … Continue reading

Posted in Oracle Database Vault, Oracle Security | Tagged | 7 Comments