ORA-01031 Database Vault Not Allowing Access After Rules Modified

(Doc ID 2408276.1)

Last updated on JULY 01, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Goal

Database Vault is enabled and a realm is in place which protects certain objects on grant, revoke, and select access.
A new schema is created in the database and the realm is modified to make the new user an owner of the realm- in line with documentation modified the existing select rule to allow selects.
finally, the required grant select on the table to the new user.

When the new user user executes the select, it gets an ORA-01031: insufficient privileges error.
The command rules, rules, and rule sets have all been reviewed and nothing is seemingly out of order that would explain occurrence of the error.

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms