Database Error Messages

Release
toggle
  • 23ai
Updated
Jun 24, 2024

OCI-42806

Cannot delete Virtual Private Database (VPD) policy group "string" as the group contains one or more policies.
  • Policy Group: The name of the policy group.

Cause

An attempt was made to delete a VPD policy group which contained one or more policies. A policy group can be dropped only if there is no policy in the group.


Action

Query DBA_POLICIES to check if there is a policy associated with the policy group which is getting deleted. If there is any such policy, drop the policy with DBMS_RLS.DROP_GROUPED_POLICY procedure. Retry DBMS_RLS.DELETE_POLICY_GROUP after dropping all policies associated with the policy group.