Last updated on NOVEMBER 10, 2016
Applies to:Oracle Database Vault - Version: 10.2.0.5
Information in this document applies to any platform.
The issue can be reproduced at will with the following steps:
1. Add a rule that has the following condition:
UPPER(SYS_CONTEXT('USERENV','SESSION_USER'))='SCOTT' and (UPPER(SYS_CONTEXT('USERENV','IP_ADDRESS'))='10.167.241.15' )
2. Create a command rule that will be attached to the rule created at step 1.
3. Create a job that is accessing the objects protected by the realm
The JOB will fail with ORA-01031
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms