[Home] [Help]
PACKAGE: SYS.XS_ADMIN_INT
Source
1 PACKAGE XS_ADMIN_INT AUTHID CURRENT_USER AS
2
3 -- Define DBMS_XS_AUDLIST type
4 TYPE DBMS_XS_AUDLIST IS VARRAY(7) OF VARCHAR2(4000);
5
6 --These constants represent dependency types.
7 ROLE_GRANT_PROXY_DEP CONSTANT PLS_INTEGER := 1;
8 SC_INHERIT_DEP CONSTANT PLS_INTEGER := 2;
9 SCOPE_ACL_DEP CONSTANT PLS_INTEGER := 3;
10 ACL_INHERIT_DEP CONSTANT PLS_INTEGER := 4;
11 PROTECT_INST_SET_DEP CONSTANT PLS_INTEGER := 5;
12 GRANT_DENY_PRNC_DEP CONSTANT PLS_INTEGER := 6;
13 ROLE_ROLESET_DEP CONSTANT PLS_INTEGER := 7;
14
15 -- These constants represent the retured value from delete_entity.
16 DELETE_SUCCESS CONSTANT PLS_INTEGER := 0;
17 WARN_DEP_EXISTS CONSTANT PLS_INTEGER := 1;
18 WARN_CONSTRIANTS_EXISTS CONSTANT PLS_INTEGER := 2;
19
20 -- These constants represent what status to be used when creating an object.
21 OBJ_WITH_STATUS_EXTERNAL CONSTANT PLS_INTEGER := 2;
22 OBJ_WITH_STATUS_EXISTS CONSTANT PLS_INTEGER := 1;
23 OBJ_WITH_STATUS_NOT_EXISTS CONSTANT PLS_INTEGER := 0;
24
25 -- These constants represent system privileges needed for operating non-schema
26 -- objects.
27 SPRIV_DBA CONSTANT PLS_INTEGER := 0;
28 SPRIV_CREATE_USER CONSTANT PLS_INTEGER := 1;
29 SPRIV_CREATE_ROLE CONSTANT PLS_INTEGER := 2;
30 SPRIV_DROP_USER CONSTANT PLS_INTEGER := 3;
31 SPRIV_DROP_ROLE CONSTANT PLS_INTEGER := 4;
32 SPRIV_GRANT_ROLE CONSTANT PLS_INTEGER := 5;
33 SPRIV_ALTER_USER CONSTANT PLS_INTEGER := 6;
34 SPRIV_ALTER_ROLE CONSTANT PLS_INTEGER := 7;
35
36 -- The following constants define Triton admin audit actions.
37 AUDIT_CREATE_USER CONSTANT PLS_INTEGER := 1;
38 AUDIT_UPDATE_USER CONSTANT PLS_INTEGER := 2;
39 AUDIT_DELETE_USER CONSTANT PLS_INTEGER := 3;
40 AUDIT_CREATE_ROLE CONSTANT PLS_INTEGER := 4;
41 AUDIT_UPDATE_ROLE CONSTANT PLS_INTEGER := 5;
42 AUDIT_DELETE_ROLE CONSTANT PLS_INTEGER := 6;
43 AUDIT_GRANT_ROLE CONSTANT PLS_INTEGER := 7;
44 AUDIT_REVOKE_ROLE CONSTANT PLS_INTEGER := 8;
45 AUDIT_ADD_PROXY CONSTANT PLS_INTEGER := 9;
46 AUDIT_REMOVE_PROXY CONSTANT PLS_INTEGER := 10;
47 AUDIT_SET_PASSWORD CONSTANT PLS_INTEGER := 11;
48 AUDIT_SET_VERIFIER CONSTANT PLS_INTEGER := 12;
49 AUDIT_CREATE_ROLESET CONSTANT PLS_INTEGER := 13;
50 AUDIT_UPDATE_ROLESET CONSTANT PLS_INTEGER := 14;
51 AUDIT_DELETE_ROLESET CONSTANT PLS_INTEGER := 15;
52 AUDIT_CREATE_SECURITY_CLASS CONSTANT PLS_INTEGER := 16;
53 AUDIT_UPDATE_SECURITY_CLASS CONSTANT PLS_INTEGER := 17;
54 AUDIT_DELETE_SECURITY_CLASS CONSTANT PLS_INTEGER := 18;
55 AUDIT_CREATE_NAMESPACE CONSTANT PLS_INTEGER := 19;
56 AUDIT_UPDATE_NAMESPACE CONSTANT PLS_INTEGER := 20;
57 AUDIT_DELETE_NAMESPACE CONSTANT PLS_INTEGER := 21;
58 AUDIT_CREATE_ACL CONSTANT PLS_INTEGER := 22;
59 AUDIT_UPDATE_ACL CONSTANT PLS_INTEGER := 23;
60 AUDIT_DELETE_ACL CONSTANT PLS_INTEGER := 24;
61 AUDIT_CREATE_DATA_SECURITY CONSTANT PLS_INTEGER := 25;
62 AUDIT_UPDATE_DATA_SECURITY CONSTANT PLS_INTEGER := 26;
63 AUDIT_DELETE_DATA_SECURITY CONSTANT PLS_INTEGER := 27;
64 AUDIT_ENABLE_DATA_SECURITY CONSTANT PLS_INTEGER := 28;
65 AUDIT_DISABLE_DATA_SECURITY CONSTANT PLS_INTEGER := 29;
66 AUDIT_ENABLE_ROLE CONSTANT PLS_INTEGER := 33;
67 AUDIT_DISABLE_ROLE CONSTANT PLS_INTEGER := 34;
68 AUDIT_SET_PROFILE CONSTANT PLS_INTEGER := 47;
69
70 -- The following constants define indices in DBMS_XS_AUDLIST.
71 AUD_TARGETPNAME CONSTANT PLS_INTEGER := 1;
72 AUD_PROXYUNAME CONSTANT PLS_INTEGER := 2;
73 AUD_POLICYNAME CONSTANT PLS_INTEGER := 3;
74 AUD_SCHEMANAME CONSTANT PLS_INTEGER := 4;
75 AUD_ENABLEDROLE CONSTANT PLS_INTEGER := 5;
76 AUD_OBJOWN CONSTANT PLS_INTEGER := 6;
77 AUD_OBJNAME CONSTANT PLS_INTEGER := 7;
78
79 -- The following constants define entity type for auditing.
80 AUD_ENTITY_TYPE_USER CONSTANT PLS_INTEGER := 1;
81 AUD_ENTITY_TYPE_SECURITY_CLASS CONSTANT PLS_INTEGER := 2;
82 AUD_ENTITY_TYPE_ACL CONSTANT PLS_INTEGER := 3;
83 AUD_ENTITY_TYPE_ROLE CONSTANT PLS_INTEGER := 4;
84 AUD_ENTITY_TYPE_DATA_SECURITY CONSTANT PLS_INTEGER := 5;
85 AUD_ENTITY_TYPE_ROLESET CONSTANT PLS_INTEGER := 6;
86 AUD_ENTITY_TYPE_NSTEMPL CONSTANT PLS_INTEGER := 7;
87
88 -- Get the entity ID
89 PROCEDURE get_entity_id(
90 obj_name IN VARCHAR2,
91 obj_type IN PLS_INTEGER,
92 obj_status OUT PLS_INTEGER,
93 obj_schema OUT VARCHAR2,
94 obj_oname OUT VARCHAR2,
95 obj_id OUT NUMBER);
96
97 -- Create a triton object
98 PROCEDURE create_entity(
99 obj_name IN VARCHAR2,
100 obj_type IN PLS_INTEGER,
101 obj_status IN PLS_INTEGER,
102 obj_id OUT NUMBER);
103
104 -- Delete a triton object
105 PROCEDURE delete_entity(
106 obj_name IN VARCHAR2,
107 obj_type IN PLS_INTEGER,
108 opt IN PLS_INTEGER,
109 obj_id IN OUT NUMBER,
110 ret_status OUT PLS_INTEGER);
111
112 -- Create a triton dependency
113 PROCEDURE create_dependency(
114 dep_type IN PLS_INTEGER,
115 obj_name1 IN VARCHAR2,
116 obj_type1 IN PLS_INTEGER,
117 obj_id1 IN OUT NUMBER,
118 obj_name2 IN VARCHAR2,
119 obj_type2 IN PLS_INTEGER,
120 obj_id2 IN OUT NUMBER);
121
122 -- Delete a triton dependency
123 PROCEDURE delete_dependency(
124 dep_type IN PLS_INTEGER,
125 obj_name1 IN VARCHAR2,
126 obj_type1 IN PLS_INTEGER,
127 obj_id1 IN OUT NUMBER,
128 obj_name2 IN VARCHAR2,
129 obj_type2 IN PLS_INTEGER,
130 obj_id2 IN OUT NUMBER);
131
132 -- Invalidate a triton object
133 PROCEDURE invalidate_entity(
134 obj_id IN NUMBER,
135 obj_type IN PLS_INTEGER,
136 cleanup_priv IN BOOLEAN := FALSE);
137
138 -- Check permisson
139 PROCEDURE check_permission(
140 obj_name IN VARCHAR2,
141 obj_type IN PLS_INTEGER,
142 sys_priv IN PLS_INTEGER := NULL,
143 is_common IN BOOLEAN := FALSE,
144 aclid IN NUMBER := NULL,
145 access_type IN PLS_INTEGER := NULL);
146
147 -- Audit wrapper
148 PROCEDURE admin_audit (
149 act IN PLS_INTEGER,
150 auderr IN PLS_INTEGER,
151 entitytype IN PLS_INTEGER,
152 audrec_index1 IN PLS_INTEGER := 0,
153 audrec1 IN VARCHAR2 := NULL,
154 audrec_index2 IN PLS_INTEGER := 0,
155 audrec2 IN VARCHAR2 := NULL,
156 audrec_index3 IN PLS_INTEGER := 0,
157 audrec3 IN VARCHAR2 := NULL);
158
159 END XS_ADMIN_INT;