Oracle | DBMS_LOGREP_UTIL

Oracle DBMS_LOGREP_UTIL_INVOK Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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