| General Information |
| Library Note |
Morgan's Library Page Header
|
| 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 |
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); |
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 |