1 PACKAGE dbms_tsdp_manage AUTHID CURRENT_USER AS
2
3 DB CONSTANT INTEGER := 1;
4 ADM CONSTANT INTEGER := 2;
5 CUSTOM CONSTANT INTEGER := 3;
6
7 -- IMPORT_DISCOVERY_RESULT : Used to import Sensitive Columns for an ADM
8 -- instance as a Clob.
9 -- Parameters:
10 -- discovery_result - The list of sensitive columns, along with the optional
11 -- list of (the definitions of) the Sensitive Column Types
12 -- as a clob.
13 -- discovery_source - The source of the import. The discovery_source
14 -- identifies the list of imported sensitive columns.
15 -- In case of ADM, this should be the ADM name.
16 -- force - TRUE/FALSE.TRUE implies the result will be imported even
17 -- though some of the columns are already identified as
18 -- sensitive. The attributes of these duplicate columns
19 -- are overwritten with the attributes corresponding to this
20 -- import. Default is FALSE.
21
22 PROCEDURE IMPORT_DISCOVERY_RESULT (
23 discovery_result IN CLOB,
24 discovery_source IN VARCHAR2,
25 force IN BOOLEAN DEFAULT FALSE);
26
27 -- IMPORT_DISCOVERY_RESULT: Used to import Sensitive Columns for an ADM
28 -- instance as XMLType.
29 -- Parameters:
30 -- discovery_result - The list of sensitive columns, along with the optional
31 -- list of (the definitions of) the Sensitive Column Types
32 -- in XML format
33 -- discovery_source - The source of the import. The discovery_source
34 -- identifies the list of imported sensitive columns.
35 -- In case of ADM, this should be the ADM name.
36 -- force - TRUE/FALSE.TRUE imploes the result will be imported even
37 -- though some of the columns are already identified as
38 -- sensitive. The attributes of these duplicate columns
39 -- are overwritten with the attributes corresponding to this
40 -- import.
41
42 PROCEDURE IMPORT_DISCOVERY_RESULT (
43 discovery_result IN XMLTYPE,
44 discovery_source IN VARCHAR2,
45 force IN BOOLEAN DEFAULT FALSE);
46
47 -- REMOVE_DISCOVERY_RESULT: Used to remove Sensitive Columns corresponding to
48 -- an ADM instance
49 -- Parameters:
50 -- discovery_source: The source of the import. In case of ADM, this should
51 -- be the ADM name, the results of which is to be removed.
52
53 PROCEDURE REMOVE_DISCOVERY_RESULT (
54 discovery_source IN VARCHAR2);
55
56 -- ADD_SENSITIVE_COLUMN: Used to add a Column to the Sensitive Column List.
57 -- Parameters:
58 -- schema_name - Schema to which the column belongs.
59 -- table_name - Table containing the column.
60 -- column_name - The sensitive column name.
61 -- sensitive_type - The identifier of the Sensitive Column Type.
62 -- user_comment - User comment regarding the sensitive column.
63
64 PROCEDURE ADD_SENSITIVE_COLUMN (
65 schema_name IN VARCHAR2,
66 table_name IN VARCHAR2,
67 column_name IN VARCHAR2,
68 sensitive_type IN VARCHAR2,
69 user_comment IN VARCHAR2 default NULL);
70
71 -- ALTER_SENSITIVE_COLUMN : Used to alter the Sensitive Type and/or the Comment
72 -- of a Column in the Sensitive Column List.
73 -- Parameters:
74 -- schema_name - Schema to which the column belongs.
75 -- table_name - Table containing the column.
76 -- column_name - The sensitive column name.
77 -- sensitive_type - The identifier of the Sensitive Column Type.
78 -- user_comment - User comment regarding the sensitive column.
79
80 PROCEDURE ALTER_SENSITIVE_COLUMN (
81 schema_name IN VARCHAR2,
82 table_name IN VARCHAR2,
83 column_name IN VARCHAR2,
84 sensitive_type IN VARCHAR2,
85 user_comment IN VARCHAR2 default NULL);
86
87 -- DROP_SENSITIVE_COLUMN : Used to remove a Column from the Sensitive Column
88 -- List.
89 -- Parameters:
90 -- schema_name - Schema to which the column belongs.
91 -- table_name - Table containing the column.
92 -- column_name - The sensitive column to be removed.
93
94 PROCEDURE DROP_SENSITIVE_COLUMN (
95 schema_name IN VARCHAR2 DEFAULT '%',
96 table_name IN VARCHAR2 DEFAULT '%',
97 column_name IN VARCHAR2 DEFAULT '%');
98
99 -- IMPORT_SENSITIVE_TYPES : Used to import a list of Sensitive Column Types
100 -- from a source as a Clob.
101 -- Parameters:
102 -- sensitive_types - The list of Sensitive Column Types as a clob.
103 -- source - The source of the import. The source identifies the list of
104 -- imported Sensitive Column Types. In case of ADM, this
105 -- should be the ADM name.
106
107 PROCEDURE IMPORT_SENSITIVE_TYPES (
108 sensitive_types IN CLOB,
109 source IN VARCHAR2);
110
111 -- IMPORT_SENSITIVE_TYPES : Used to import a list of Sensitive Column Types
112 -- from a source as XMLType.
113 -- Parameters:
114 -- sensitive_types - The list of Sensitive Column Types in XML Format.
115 -- source - The source of the import. The source identifies the list of
116 -- imported Sensitive Column Types. In case of ADM, this
117 -- should be the ADM name.
118
119 PROCEDURE IMPORT_SENSITIVE_TYPES (
120 sensitive_types IN XMLTYPE,
121 source IN VARCHAR2);
122
123 -- ADD_SENSITIVE_TYPE : Used to create and add a Sensitive Column Type to the
124 -- list Sensitive Column Types in the database.
125 -- Parameters:
126 -- sensitive_type - Name of the Sensitive Column Type.
127 -- user_comment - User comment regarding the sensitive column.
128
129 PROCEDURE ADD_SENSITIVE_TYPE (
130 sensitive_type IN VARCHAR2,
131 user_comment IN VARCHAR2 DEFAULT NULL);
132
133 -- DROP_SENSITIVE_TYPE : Used to drop a Sensitive Column Type from the list
134 -- Sensitive Column Types in the database.
135 -- Parameters:
136 -- sensitive_type - Name of the Sensitive Column Type that is to be dropped.
137
138 PROCEDURE DROP_SENSITIVE_TYPE (
139 sensitive_type IN VARCHAR2);
140
141 -- DROP_SENSITIVE_TYPE_SOURCE : Used to drop Sensitive Column Types
142 -- corresponding to a Source from the list
143 -- Sensitive Column Types in the database.
144 -- Parameters:
145 -- source_name - Name of the Source.
146
147 PROCEDURE DROP_SENSITIVE_TYPE_SOURCE (
148 source IN VARCHAR2);
149
150 END dbms_tsdp_manage;