Public Synonyms To Some LBACSYS Objects Incorrect
Last updated on APRIL 09, 2018
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Information in this document applies to any platform.
After upgrade from 220.127.116.11 to 18.104.22.168, 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