Oracle  XS_DATA_SECURITY_UTIL
Version 12.1.0.2

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose Real Application Security
AUTHID DEFINER
Constants
Name Data Type Value
ACLMV Refresh_Modes
ACLMV_ON_DEMAND VARCHAR2(9) 'ON DEMAND';
ACLMV_ON_COMMIT VARCHAR2(9) 'ON COMMIT'
Static Refresh Types for Static ACL MV
XS_ON_COMMIT_MV BINARY_INTEGER 0
XS_ON_DEMAND_MV BINARY_INTEGER 1
XS_SCHEDULED_MV BINARY_INTEGER 2
Static ACL MV Types
XS_SYSTEM_GENERATED_MV BINARY_INTEGER 0
XS_USER_SPECIFIED_MV BINARY_INTEGER 1
Data Types TYPE objnametype IS TABLE OF VARCHAR2(32) INDEX BY BINARY_INTEGER;

TYPE objnumtype IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
Dependencies
ACLMV$ DBMS_SCHEDULER DBMS_XDS_LIB
ACLMV$_REFLOG DBMS_SNAP_INTERNAL OBJ$
ACLMVREFSTAT$ DBMS_SQL PLITBLM
ALL_MVIEWS DBMS_SYSTEM SNAP$
DBMS_ASSERT DBMS_SYS_SQL USER$
DBMS_MVIEW DBMS_XDS XS_ADMIN_UTIL
DBMS_OUTPUT    
Documented Partially
Exceptions
Error Code Reason
46025 No static rule specified in applied policy
First Available 12cR1
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/xsds.sql
Subprograms
 
ALTER_STATIC_ACL_REFRESH
Alters the refresh mode for a ACL MV removing any refresh schedules xs_data_security_util.alter_static_acl_refresh(
schema_name  IN VARCHAR2 := NULL,
table_name   IN VARCHAR2,
refresh_mode IN VARCHAR2);
exec xs_data_security_util.alter_static_acl_refresh('UWCLASS', 'SERVERS', xs_data_security_util.aclmv_on_commit);
 
PURGE_ACL_REFRESH_HISTORY
Purges contents for the table's ACL MV xs_data_security_util.purge_acl_refresh_history(
object_schema IN VARCHAR2 := NULL,
object_name   IN VARCHAR2,
purge_date    IN DATE := NULL);
exec xs_data_security_util.purge_acl_refresh_history('UWCLASS', 'SERVERS', SYSDATE);

SELECT *
FROM sys.aclmvrefstat$;
 
SCHEDULE_STATIC_ACL_REFRESH
Schedules automatic refresh of an ACL MV changing the refresh mode to "ON DEMAND" xs_data_security_util.schedule_static_acl_refresh(
schema_name     IN VARCHAR2                 := NULL,
table_name      IN VARCHAR2,
start_date      IN TIMESTAMP WITH TIME ZONE := NULL,
repeat_interval IN VARCHAR2                 := NULL,
comments        IN VARCHAR2                 := NULL);
exec xs_data_security_util.schedule_static_acl_refresh('UWCLASS', 'SERVERS', SYSTIMESTAMP+1, 'freq=hourly; interval=4', 'Refresh On Demand');
 
SET_TRACE_LEVEL
Sets the debugging trace level xs_data_security_util.set_trace_level(
schema_name IN VARCHAR2,
table_name  IN VARCHAR2,
level       IN NUMBER);
exec xs_data_security_util.set_trace_level('UWCLASS', 'SERVERS', 8);

SELECT *
FROM sys.aclmv$_reflog;
 
XS$REFRESH_STATIC_ACL
Scheduler callback procedure to refresh an acl-mv xs_data_security_util.xs$refresh_static_acl(
schema_name IN VARCHAR2,
table_name  IN VARCHAR2,
mview_name  IN VARCHAR2,
job_name    IN VARCHAR2);
exec xs_data_security_util.xs$refresh_static_acl('SEC_MGR', 'SECTAB', 'SEC_TAB_MV', 'SECJOB');

Related Topics
DBMS_XS_PRINCIPALS
DBMS_XS_SESSIONS
DBMS_XS_SESSIONS_FFI
DBMS_XS_SIDP
DBMS_XS_SYSTEM
DBMS_XS_SYSTEM_FFI
Packages
XS_ACL
XS_ADMIN_UTIL
XS_DATA_SECURITY
XS_DIAG
XS_DIAG_INT
XS_NAMESPACE
XS_PRINCIPAL
XS_SECURITY_CLASS
What's New In 12cR1
What's New In 12cR2

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-2017 Daniel A. Morgan All Rights Reserved