ORA-01031 Database Vault Not Allowing Access After Rules Modified
Last updated on JULY 01, 2018
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Information in this document applies to any platform.
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.
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