My Oracle Support Banner

Invalid Public Synonyms After Removing Database Vault and Oracle Label Security on 12c (Doc ID 2756420.1)

Last updated on APRIL 11, 2021

Applies to:

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

Goal

Oracle Label Security and Database Vault were dropped on a 12c database.

With this action, 121 public synonyms became invalid:

OBJECT_NAME
ALL_SA_AUDIT_OPTIONS
ALL_SA_COMPARTMENTS
ALL_SA_DATA_LABELS
ALL_SA_GROUPS
ALL_SA_GROUP_HIERARCHY
ALL_SA_LABELS
ALL_SA_LEVELS
ALL_SA_POLICIES
ALL_SA_PROG_PRIVS
ALL_SA_SCHEMA_POLICIES
ALL_SA_TABLE_POLICIES
ALL_SA_USERS
ALL_SA_USER_COMPARTMENTS
ALL_SA_USER_GROUPS
ALL_SA_USER_LABELS
ALL_SA_USER_LEVELS
ALL_SA_USER_PRIVS
CDB_LBAC_POLICIES
CDB_LBAC_SCHEMA_POLICIES
CDB_LBAC_TABLE_POLICIES
CDB_OLS_STATUS
CDB_SA_AUDIT_OPTIONS
CDB_SA_COMPARTMENTS
CDB_SA_DATA_LABELS
CDB_SA_GROUPS
CDB_SA_GROUP_HIERARCHY
CDB_SA_LABELS
CDB_SA_LEVELS
CDB_SA_POLICIES
CDB_SA_PROGRAMS
CDB_SA_PROG_PRIVS
CDB_SA_SCHEMA_POLICIES
CDB_SA_TABLE_POLICIES
CDB_SA_USERS
CDB_SA_USER_COMPARTMENTS
CDB_SA_USER_GROUPS
CDB_SA_USER_LABELS
CDB_SA_USER_LEVELS
CDB_SA_USER_PRIVS
CHAR_TO_LABEL
DBA_LBAC_POLICIES
DBA_LBAC_SCHEMA_POLICIES
DBA_LBAC_TABLE_POLICIES
DBA_OLS_STATUS
DBA_SA_AUDIT_OPTIONS
DBA_SA_COMPARTMENTS
DBA_SA_DATA_LABELS
DBA_SA_GROUPS
DBA_SA_GROUP_HIERARCHY
DBA_SA_LABELS
DBA_SA_LEVELS
DBA_SA_POLICIES
DBA_SA_PROGRAMS
DBA_SA_PROG_PRIVS
DBA_SA_SCHEMA_POLICIES
DBA_SA_TABLE_POLICIES
DBA_SA_USERS
DBA_SA_USER_COMPARTMENTS
DBA_SA_USER_GROUPS
DBA_SA_USER_LABELS
DBA_SA_USER_LEVELS
DBA_SA_USER_PRIVS
DOMINATED_BY
DOMINATES
DOM_BY
GLBD
GREATEST_LBOUND
LABEL_TO_CHAR
LBAC_AUDIT_ACTIONS
LBAC_LABEL_TO_CHAR
LBAC_POLICY_ADMIN
LBAC_SESSION
LBAC_TO_NUMERIC
LBAC_UTL
LDAP_ATTR
LDAP_ATTR_LIST
LDAP_EVENT
LDAP_EVENT_STATUS
LEAST_UBOUND
LUBD
MERGE_LABEL
NUMERIC_LABEL_TO_CHAR
NUMERIC_TO_LBAC
OID_ENABLED
OLS_DIP_NTFY
OLS_DOM
OLS_DOMINATED_BY
OLS_DOMINATES
OLS_DOM_BY
OLS_GLBD
OLS_GREATEST_LBOUND
OLS_LABEL_DOMINATES
OLS_LEAST_UBOUND
OLS_LUBD
OLS_STRICTLY_DOMINATED_BY
OLS_STRICTLY_DOMINATES
OLS_S_DOM
OLS_S_DOM_BY
ORA_GET_AUDITED_LABEL
PRIVS_TO_CHAR
SA_AUDIT_ADMIN
SA_COMPONENTS
SA_LABEL_ADMIN
SA_POLICY_ADMIN
SA_SESSION
SA_SYSDBA
SA_USER_ADMIN
SA_UTL
SP_AEC_NEW_CONTRACT_LOAD
STRICTLY_DOMINATED_BY
STRICTLY_DOMINATES
S_DOM
S_DOM_BY
TAGSEQ_TO_CHAR
TO_DATA_LABEL
TO_LABEL_LIST
TO_LBAC_DATA_LABEL
TO_LBAC_LABEL
TO_NUMERIC_DATA_LABEL
TO_NUMERIC_LABEL
USER_SA_SESSION


Is it OK to drop these objects (on 12c)?

Solution

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
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.