Oracle DBMS_SNAPSHOT_COMMON
Version 19.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 Supporting package for Materialized Views and Snapshots
AUTHID DEFINER
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 18c
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvtsnps.plb
Subprograms
 
CHECK_PRIVS_ON_TABLE
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

Related Topics
Built-in Functions
Built-in Packages
DBMS_MVIEW
DBMS_SNAPSHOT_KKXRCA
DBMS_SNAPSHOT_UTL
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