Public Synonyms To Some LBACSYS Objects Incorrect
Last updated on FEBRUARY 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
After upgrade from 126.96.36.199 to 188.8.131.52, several public synonyms to LBACSYS objects are incorrect
SA_AUDIT_ADMIN incorrectly points to LBACSYS.LBAC_AUDIT_ADMIN
SA_LABEL_ADMIN incorrectly points to LBACSYS.LBAC_LABEL_ADMIN
SA_POLICY_ADMIN incorrectly points to LBACSYS.LBAC_POLICY_ADMIN
TAGSEQ_TO_CHAR incorrectly points to LBACSYS.NUMERIC_LABEL_TAGSEQ_TO_CHAR
Issue is traced to PUBLIC synonym creation in $ORACLE_HOME/rdbms/admin/prvtolsdd.plb where PUBLIC synonyms created with CREATE SYNONYM syntax instead of CREATE OR REPLACE SYNONYM syntax.
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