PACKAGE: SYS.XS_DATA_SECURITY

Source

1 PACKAGE XS_DATA_SECURITY AUTHID CURRENT_USER AS
2 
3 -- Apply policy options
4   APPLY_DYNAMIC_IS          CONSTANT   PLS_INTEGER := 1;
5   APPLY_ACLOID_COLUMN       CONSTANT   PLS_INTEGER := 2;
6   APPLY_STATIC_IS           CONSTANT   PLS_INTEGER := 3;
7 
8 -- Enable log based replication for this package
9 PRAGMA SUPPLEMENTAL_LOG_DATA(default, AUTO);
10 
11 -- Create data security policy
12 PROCEDURE CREATE_POLICY (
13           name                     IN VARCHAR2,
14           realm_constraint_list    IN  XS$REALM_CONSTRAINT_LIST,
15           column_constraint_list   IN  XS$COLUMN_CONSTRAINT_LIST := NULL,
16           description              IN VARCHAR2 := NULL
17           );
18 
19 -- Add a realm constraint to data security
20 PROCEDURE APPEND_REALM_CONSTRAINTS (
21           policy                IN VARCHAR2,
22           realm_constraint      IN XS$REALM_CONSTRAINT_TYPE
23           );
24 
25 -- Add a list of realm constraints to data security
26 PROCEDURE APPEND_REALM_CONSTRAINTS (
27           policy                IN VARCHAR2,
28           realm_constraint_list IN XS$REALM_CONSTRAINT_LIST
29           );
30 
31 -- Remove all realm constraints
32 PROCEDURE REMOVE_REALM_CONSTRAINTS (
33           policy                IN VARCHAR2
34           );
35 
36 -- Add a column constraint to data security
37 PROCEDURE ADD_COLUMN_CONSTRAINTS (
38           policy             IN VARCHAR2,
39           column_constraint  IN XS$COLUMN_CONSTRAINT_TYPE
40           );
41 
42 -- Add column constraints to data security
43 PROCEDURE ADD_COLUMN_CONSTRAINTS (
44           policy                   IN VARCHAR2,
45           column_constraint_list   IN XS$COLUMN_CONSTRAINT_LIST
46           );
47 
48 -- Remove all column constraints of data security
49 PROCEDURE REMOVE_COLUMN_CONSTRAINTS (
50           policy                IN VARCHAR2
51           );
52 
53 -- Create an ACL paramter
54 PROCEDURE CREATE_ACL_PARAMETER (
55           policy               IN VARCHAR2,
56           parameter            IN VARCHAR2,
57           param_type           IN NUMBER
58           );
59 
60 -- Delete an ACL parameter
61 PROCEDURE DELETE_ACL_PARAMETER (
62           policy                IN VARCHAR2,
63           parameter             IN VARCHAR2,
64           delete_option         IN PLS_INTEGER := XS_ADMIN_UTIL.DEFAULT_OPTION
65           );
66 
67 -- Set the description of data security
68 PROCEDURE SET_DESCRIPTION (
69           policy                 IN VARCHAR2,
70           description            IN VARCHAR2
71           );
72 
73 
74 -- Delete data security policy
75 PROCEDURE DELETE_POLICY(
76           policy                IN VARCHAR2,
77           delete_option         IN PLS_INTEGER := XS_ADMIN_UTIL.DEFAULT_OPTION
78           );
79 
80 -- apply_object_policy -  Apply XDS policy on a table
81 PROCEDURE APPLY_OBJECT_POLICY(
82           policy          IN VARCHAR2,
83           schema          IN VARCHAR2,
84           object          IN VARCHAR2,
85           row_acl         IN BOOLEAN  := FALSE,
86           owner_bypass    IN BOOLEAN  := FALSE,
87           statement_types IN VARCHAR2 := NULL,
88           aclmv           IN VARCHAR2 := NULL
89           );
90 
91 -- enable_object_policy - disable an XDS policy for a table
92 PROCEDURE ENABLE_OBJECT_POLICY(
93           policy IN VARCHAR2,
94           schema IN VARCHAR2,
95           object IN VARCHAR2
96           );
97 
98 -- disable_object_policy - disable an XDS policy for a table
99 PROCEDURE DISABLE_OBJECT_POLICY(
100           policy IN VARCHAR2,
101           schema IN VARCHAR2,
102           object IN VARCHAR2
103           );
104 
105 -- remove_object_policy - remove an XDS policy from a table
106 PROCEDURE REMOVE_OBJECT_POLICY(
107           policy IN VARCHAR2,
108           schema IN VARCHAR2,
109           object IN VARCHAR2
110           );
111 
112 END XS_DATA_SECURITY;