ORA-01031 Database Vault Not Allowing Access After Rules Modified
(Doc ID 2408276.1)
Last updated on JUNE 10, 2021
Applies to:Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A 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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document