Oracle  XS_DATA_SECURITY_UTIL_INT
Version 18.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 Real Application Security

The following important note is in the create script
-- Bug 23597785: rename XS_DATA_SECURITY_UTIL to XS_DATA_SECURITY_UTIL_INT
CREATE OR REPLACE PACKAGE XS_DATA_SECURITY_UTIL_INT
ACCESSIBLE BY (PACKAGE XS_DATA_SECURITY_UTIL) AS

XS_DATA_SECURITY_UTIL was modified as follows -- Bug 23597785: Create XS_DATA_SECURITY_UTIL with invoker rights
AUTHID CURRENT_USER
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
DBMS_PRIV_CAPTURE DBMS_XDS_INT XS_ADMIN_UTIL
DBMS_SYS_ERROR DBMS_XDS_LIB XS_DATA_SECURITY_UTIL
Documented Partially
Exceptions
Error Code Reason
46025 No static rule specified in applied policy
First Available 12.2.0.1
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvtds.plb
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);
No demo possible due to ACCESSIBLE BY Clause
 
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);
No demo possible due to ACCESSIBLE BY Clause
 
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);
No demo possible due to ACCESSIBLE BY Clause
 
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);
No demo possible due to ACCESSIBLE BY Clause
 
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);
No demo possible due to ACCESSIBLE BY Clause

Related Topics
Built-in Functions
Built-in Packages
DBMS_XS_PRINCIPALS
DBMS_XS_SESSIONS
DBMS_XS_SESSIONS_FFI
DBMS_XS_SIDP
DBMS_XS_SYSTEM
DBMS_XS_SYSTEM_FFI
XS_ACL
XS_ADMIN_UTIL
XS_DATA_SECURITY_UTIL
XS_DIAG
XS_DIAG_INT
XS_NAMESPACE
XS_PRINCIPAL
XS_SECURITY_CLASS
What's New In 18cR3
What's New In 19cR3

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