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
Undocumented
AUTHID
DEFINER
Dependencies
ALL_OBJECTS
DBMS_ISYNCREF
OBJ$
ALL_PART_KEY_COLUMNS
DBMS_SNAPSHOT_COMMON
PLITBLM
ALL_PART_TABLES
DBMS_SNAPSHOT_LIB
SUMDETAIL$
ALL_TAB_PARTITIONS
DBMS_STANDARD
SYNCREF$_GROUP_STATUS
CANSYNCREFARRAYTYPE
DBMS_SYNC_REFRESH
SYNCREF$_OBJECTS
DBA_OBJECTS
DBMS_SYSTEM
SYNCREF$_OBJECT_STATUS
DBMS_ASSERT
DBMS_SYS_ERROR
SYNCREF$_PARAMETERS
DBMS_IREFRESH
DBMS_UTILITY
SYNCREF$_PARTN_OPS
DBMS_ISNAPSHOT
DUAL
USER$
Documented
No
First Available
Not known
Security Model
Owned by SYS with no privileges granted.
Direct access to this package is prevented by means of an Accessible By clause.
exec dbms_sync_refresh_internal.abort_refresh;
BEGIN dbms_sync_refresh_internal.abort_refresh; END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00904: insufficient privilege to access object DBMS_SYNC_REFRESH_INTERNAL
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Overload 2
dbms_sync_refresh_internal.abort_refresh(retention IN NUMBER);
dbms_sync_refresh_internal.alter_refresh_stats_retention(retention IN NUMBER);
exec dbms_sync_refresh_internal.alter_refresh_stats_retention(30);
BEGIN dbms_sync_refresh_internal.alter_refresh_stats_retention; END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00904: insufficient privilege to access object DBMS_SYNC_REFRESH_INTERNAL
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
dbms_sync_refresh_internal.can_syncref_table(
schema_name IN VARCHAR2,
table_name IN VARCHAR2,
statement_id IN VARCHAR2,
cuser IN VARCHAR2);
TBD
Overload 2
dbms_sync_refresh_internal.can_syncref_table(
schema_name IN VARCHAR2,
table_name IN VARCHAR2,
output_array IN OUT sys.cansyncrefarraytype,
cuser IN
VARCHAR2);
dbms_sync_refresh_internal.register_partition_operation(
partition_op IN VARCHAR2,
schema_name IN VARCHAR2,
base_table_name IN VARCHAR2,
partition_name IN VARCHAR2,
outside_partn_table_schema IN VARCHAR2,
outside_partn_table_name IN VARCHAR2,
validation IN BOOLEAN);
dbms_sync_refresh_internal.unregister_partition_operation(
partition_op IN VARCHAR2,
schema_name IN VARCHAR2,
base_table_name IN VARCHAR2,
partition_name IN VARCHAR2);