Public Synonyms To Some LBACSYS Objects Incorrect
(Doc ID 2350010.1)
Last updated on AUGUST 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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!