Oracle | DBMS_LOGREP_UTIL

Oracle DBMS_LOGREP_UTIL_INVOK Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Internal support for log file replication utilities

AUTHID CURRENT_USER

Dependencies

DBMS_APPLY_ADM	DBMS_LOGREP_LIB	DBMS_STREAMS_ADM_UTL
DBMS_APPLY_ADM_INTERNAL	DBMS_LOGREP_UTIL	DBMS_STREAMS_ADM_UTL_INVOK
DBMS_APPLY_ADM_IVK	DBMS_PRIV_CAPTURE	DBMS_STREAMS_MT
DBMS_CAPTURE_ADM	DBMS_PROPAGATION_INTERNAL	DBMS_STREAMS_TABLESPACE_ADM
DBMS_CAPTURE_ADM_INTERNAL	DBMS_RECO_SCRIPT_INVOK	DBMS_XSTREAM_ADM
DBMS_CAPTURE_ADM_IVK	DBMS_STREAMS_ADM	DBMS_XSTREAM_ADM_UTL
DBMS_FILE_GROUP	DBMS_STREAMS_ADM_IVK	DBMS_XSTREAM_UTL_IVK

Documented No

First Available 12.2

Security Model Owned by SYS with no privileges granted.

Source {ORACLE_HOME}/rdbms/admin/prvthlut.plb

Subprograms

CHECK_BECOME_USER_PRIVILEGE	CHECK_PDB_ACCESS	GET_OBJECT_NAME
CHECK_DV_STREAMS_ADMIN

CHECK_BECOME_USER_PRIVILEGE

Undocumented dbms_logrep_util_invok.check_become_user_privilege( user_name IN VARCHAR2, check_dv IN BOOLEAN);

exec dbms_logrep_util_invok.check_become_user_privilege('UWCLASS', FALSE);

CHECK_DV_STREAMS_ADMIN

Undocumented dbms_logrep_util_invok.check_dv_streams_admin(user_name IN VARCHAR2) RETURN BOOLEAN;

BEGIN

        IF dbms_logrep_util_invok.check_dv_streams_admin('UWCLASS') THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

CHECK_PDB_ACCESS

Not sure what it is supposed to do but it doesn't seem to do anything even if you give it an invalid PDB name or a name that could never be valid as show at right. dbms_logrep_util_invok.check_pdb_access(contaier_in VARCHAR2);

exec dbms_logrep_util_invok.check_pdb_access('PDBDEV');

      

      exec dbms_logrep_util_invok.check_pdb_access('PDB DEV');

GET_OBJECT_NAME

Undocumented dbms_logrep_util_invok.get_object_name( object_name IN VARCHAR2, canon_owner OUT VARCHAR2, canon_name OUT VARCHAR2, canon_schema IN VARCHAR2, allow_3X_iden IN BOOLEAN);

DECLARE

       oOwner VARCHAR2(30);

       oName  VARCHAR2(30);

      BEGIN

        dbms_logrep_util_invok.get_object_name('SALES', oOwner, oName, 'C##SH', FALSE);

        dbms_output.put_line(oOwner);

        dbms_output.put_line(oName);

      END;

      /

      C##SH

      SALES