Oracle | DBMS_SNAPSHOT

Oracle DBMS_SNAPSHOT_COMMON 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 Supporting package for Materialized Views and Snapshots

AUTHID CURRENT_USER

Dependencies

DBMS_MVIEW_STATS	DBMS_SNAPSHOT	DBMS_SYNC_REFRESH
DBMS_PRIV_CAPTURE	DBMS_SNAPSHOT_LIB	DBMS_SYNC_REFRESH_INTERNAL
DBMS_REFRESH	DBMS_STANDARD	DBMS_SYS_ERROR

Documented No

First Available 18.1

Security Model Owned by SYS with no privileges granted

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

Subprograms

Just a guess but inputs are not being validated. There is no schema or table as named. dbms_snapshot_common.check_privs_on_table( schema_name IN VARCHAR2 table_name IN VARCHAR2 priv_flag IN BINARY_INTEGER);

exec dbms_snapshot_common.check_privs_on_table('ABC', 'DEF', 1);

      

      PL/SQL procedure successfully completed.

CHECK_USER

Just a guess but input is not being validated. There is no schema as named. dbms_snapshot_common.check_user(myowner IN VARCHAR2);

SQL> exec dbms_snapshot_common.check_user('ZZYZX');

      

      PL/SQL procedure successfully completed.

HAS_DBA_PRIV

Returns TRUE if the current session has DBA the DBA role dbms_snapshot_common.has_dba_priv RETURN BOOLEAN;

BEGIN

        IF dbms_snapshot_common.has_dba_priv THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      T