Deactivate a data access policy

Deactivating a data access policy removes the specified data access from all the users assigned to it, though users may have access through a different data access policy.

1. On the database server, log in to SQL*Plus as CDM.
2. Run stored procedure VPD_UTIL.INACTIVATE_CONFIG, entering the data access policy name for I_EXISTING_CONFIG_NAME:

   exec VPD_UTIL.INACTIVATE_CONFIG;