Oracle DBMS_LOGREP_UTIL_INVOK
Version 18.3

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_INVOK
DBMS_APPLY_ADM_INTERNAL DBMS_LOGREP_UTIL DBMS_STREAMS_MC
DBMS_APPLY_ADM_IVK DBMS_PRIV_CAPTURE DBMS_STREAMS_MESSAGING
DBMS_APPLY_HANDLER_ADM DBMS_PROPAGATION_INTERNAL DBMS_STREAMS_MT
DBMS_CAPTURE_ADM DBMS_RECO_SCRIPT_INVOK DBMS_STREAMS_TABLESPACE_ADM
DBMS_CAPTURE_ADM_INTERNAL DBMS_STREAMS_ADM DBMS_XSTREAM_ADM
DBMS_CAPTURE_ADM_IVK DBMS_STREAMS_ADM_IVK DBMS_XSTREAM_ADM_UTL
DBMS_FILE_GROUP DBMS_STREAMS_ADM_UTL 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
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 (new 18.1)
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 (new 18.1)
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

Related Topics
Built-in Functions
Built-in Packages
DBMS_LOGREP_DEFPROC_UTL
DBMS_LOGREP_EXP
DBMS_LOGREP_IMP
DBMS_LOGREP_IMP_INTERNAL
DBMS_LOGREP_UTIL
What's New In 18c
What's New In 19c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx