-
Notifications
You must be signed in to change notification settings - Fork 31
/
template.schema.sql
145 lines (144 loc) · 6.11 KB
/
template.schema.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
-- USER SQL
CREATE USER TEMPLATE_USER IDENTIFIED BY TEMPLATE_USER
DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP"
QUOTA UNLIMITED ON users;
-- SYSTEM PRIVILEGES
GRANT ALTER TABLESPACE TO TEMPLATE_USER ;
GRANT DROP ANY TRIGGER TO TEMPLATE_USER ;
GRANT CREATE ANY OUTLINE TO TEMPLATE_USER ;
GRANT ALTER ANY SEQUENCE TO TEMPLATE_USER ;
GRANT ALTER ANY LIBRARY TO TEMPLATE_USER ;
GRANT ADMINISTER SQL MANAGEMENT OBJECT TO TEMPLATE_USER ;
GRANT CREATE MINING MODEL TO TEMPLATE_USER ;
GRANT UPDATE ANY TABLE TO TEMPLATE_USER ;
GRANT CREATE TRIGGER TO TEMPLATE_USER ;
GRANT DROP ANY EVALUATION CONTEXT TO TEMPLATE_USER ;
GRANT DEBUG CONNECT SESSION TO TEMPLATE_USER ;
GRANT DROP ANY DIRECTORY TO TEMPLATE_USER ;
GRANT CREATE ASSEMBLY TO TEMPLATE_USER ;
GRANT SELECT ANY CUBE TO TEMPLATE_USER ;
GRANT CREATE SEQUENCE TO TEMPLATE_USER ;
GRANT ON COMMIT REFRESH TO TEMPLATE_USER ;
GRANT SELECT ANY SEQUENCE TO TEMPLATE_USER ;
GRANT CREATE ANY SQL PROFILE TO TEMPLATE_USER ;
GRANT ADMINISTER ANY SQL TUNING SET TO TEMPLATE_USER ;
GRANT ADVISOR TO TEMPLATE_USER ;
GRANT ALTER ANY MINING MODEL TO TEMPLATE_USER ;
GRANT EXECUTE ANY OPERATOR TO TEMPLATE_USER ;
GRANT ALTER PROFILE TO TEMPLATE_USER ;
GRANT EXECUTE ANY TYPE TO TEMPLATE_USER ;
GRANT CREATE TABLE TO TEMPLATE_USER ;
GRANT CREATE ANY INDEX TO TEMPLATE_USER ;
GRANT ADMINISTER RESOURCE MANAGER TO TEMPLATE_USER ;
GRANT BECOME USER TO TEMPLATE_USER ;
GRANT DROP ANY MINING MODEL TO TEMPLATE_USER ;
GRANT EXECUTE ASSEMBLY TO TEMPLATE_USER ;
GRANT SELECT ANY TABLE TO TEMPLATE_USER ;
GRANT CREATE OPERATOR TO TEMPLATE_USER ;
GRANT ALTER PUBLIC DATABASE LINK TO TEMPLATE_USER ;
GRANT CREATE ANY PROCEDURE TO TEMPLATE_USER ;
GRANT DROP ANY INDEXTYPE TO TEMPLATE_USER ;
GRANT SELECT ANY MINING MODEL TO TEMPLATE_USER ;
GRANT EXECUTE ANY CLASS TO TEMPLATE_USER ;
GRANT CREATE ANY MATERIALIZED VIEW TO TEMPLATE_USER ;
GRANT SELECT ANY TRANSACTION TO TEMPLATE_USER ;
GRANT ANALYZE ANY DICTIONARY TO TEMPLATE_USER ;
GRANT CREATE EXTERNAL JOB TO TEMPLATE_USER ;
GRANT INSERT ANY TABLE TO TEMPLATE_USER ;
GRANT CREATE LIBRARY TO TEMPLATE_USER ;
GRANT CREATE JOB TO TEMPLATE_USER ;
GRANT CREATE ANY OPERATOR TO TEMPLATE_USER ;
GRANT CREATE ANY LIBRARY TO TEMPLATE_USER ;
GRANT CREATE ANY SEQUENCE TO TEMPLATE_USER ;
GRANT CREATE CLUSTER TO TEMPLATE_USER ;
GRANT CREATE EVALUATION CONTEXT TO TEMPLATE_USER ;
GRANT DROP ANY OPERATOR TO TEMPLATE_USER ;
GRANT EXECUTE ANY INDEXTYPE TO TEMPLATE_USER ;
GRANT LOCK ANY TABLE TO TEMPLATE_USER ;
GRANT DROP ANY TYPE TO TEMPLATE_USER ;
GRANT CHANGE NOTIFICATION TO TEMPLATE_USER ;
GRANT DROP ANY DIMENSION TO TEMPLATE_USER ;
GRANT READ ANY FILE GROUP TO TEMPLATE_USER ;
GRANT CREATE ANY RULE TO TEMPLATE_USER ;
GRANT ALTER ANY ASSEMBLY TO TEMPLATE_USER ;
GRANT ALTER ROLLBACK SEGMENT TO TEMPLATE_USER ;
GRANT CREATE ANY VIEW TO TEMPLATE_USER ;
GRANT CREATE PROCEDURE TO TEMPLATE_USER ;
GRANT ANALYZE ANY TO TEMPLATE_USER ;
GRANT ALTER ANY TYPE TO TEMPLATE_USER ;
GRANT DROP ANY EDITION TO TEMPLATE_USER ;
GRANT CREATE ANY TRIGGER TO TEMPLATE_USER ;
GRANT ALTER ANY RULE SET TO TEMPLATE_USER ;
GRANT DROP ANY SEQUENCE TO TEMPLATE_USER ;
GRANT DROP ANY TABLE TO TEMPLATE_USER ;
GRANT EXECUTE ANY RULE TO TEMPLATE_USER ;
GRANT EXECUTE ANY PROCEDURE TO TEMPLATE_USER ;
GRANT DROP ANY VIEW TO TEMPLATE_USER ;
GRANT CREATE ANY JOB TO TEMPLATE_USER ;
GRANT DELETE ANY CUBE DIMENSION TO TEMPLATE_USER ;
GRANT CREATE ANY INDEXTYPE TO TEMPLATE_USER ;
GRANT ADMINISTER SQL TUNING SET TO TEMPLATE_USER ;
GRANT EXECUTE ANY PROGRAM TO TEMPLATE_USER ;
GRANT ALTER DATABASE LINK TO TEMPLATE_USER ;
GRANT ALTER ANY PROCEDURE TO TEMPLATE_USER ;
GRANT MERGE ANY VIEW TO TEMPLATE_USER ;
GRANT CREATE ANY EVALUATION CONTEXT TO TEMPLATE_USER ;
GRANT ALTER ANY OPERATOR TO TEMPLATE_USER ;
GRANT COMMENT ANY MINING MODEL TO TEMPLATE_USER ;
GRANT EXECUTE ANY ASSEMBLY TO TEMPLATE_USER ;
GRANT EXECUTE ANY RULE SET TO TEMPLATE_USER ;
GRANT ALTER ANY TRIGGER TO TEMPLATE_USER ;
GRANT UNDER ANY TABLE TO TEMPLATE_USER ;
GRANT BACKUP ANY TABLE TO TEMPLATE_USER ;
GRANT CREATE SYNONYM TO TEMPLATE_USER ;
GRANT ALTER DATABASE TO TEMPLATE_USER ;
GRANT ALTER ANY TABLE TO TEMPLATE_USER ;
GRANT CREATE VIEW TO TEMPLATE_USER ;
GRANT EXECUTE ANY LIBRARY TO TEMPLATE_USER ;
GRANT DROP ANY INDEX TO TEMPLATE_USER ;
GRANT CREATE TYPE TO TEMPLATE_USER ;
GRANT EXECUTE ANY EVALUATION CONTEXT TO TEMPLATE_USER ;
GRANT ALTER RESOURCE COST TO TEMPLATE_USER ;
GRANT ALTER ANY CLUSTER TO TEMPLATE_USER ;
GRANT ALTER ANY INDEX TO TEMPLATE_USER ;
GRANT CREATE ANY MINING MODEL TO TEMPLATE_USER ;
GRANT CREATE ANY RULE SET TO TEMPLATE_USER ;
GRANT CREATE MEASURE FOLDER TO TEMPLATE_USER ;
GRANT RESTRICTED SESSION TO TEMPLATE_USER ;
GRANT DROP ANY PROCEDURE TO TEMPLATE_USER ;
GRANT ALTER USER TO TEMPLATE_USER ;
GRANT CREATE ANY SYNONYM TO TEMPLATE_USER ;
GRANT ALTER ANY OUTLINE TO TEMPLATE_USER ;
GRANT ENQUEUE ANY QUEUE TO TEMPLATE_USER ;
GRANT CREATE ANY TABLE TO TEMPLATE_USER ;
GRANT SELECT ANY CUBE DIMENSION TO TEMPLATE_USER ;
GRANT ALTER ANY EVALUATION CONTEXT TO TEMPLATE_USER ;
GRANT CREATE SESSION TO TEMPLATE_USER ;
GRANT DEQUEUE ANY QUEUE TO TEMPLATE_USER ;
GRANT QUERY REWRITE TO TEMPLATE_USER ;
GRANT RESUMABLE TO TEMPLATE_USER ;
GRANT UNLIMITED TABLESPACE TO TEMPLATE_USER ;
GRANT DROP ANY OUTLINE TO TEMPLATE_USER ;
GRANT CREATE ANY EDITION TO TEMPLATE_USER ;
GRANT CREATE ANY ASSEMBLY TO TEMPLATE_USER ;
GRANT ALTER ANY INDEXTYPE TO TEMPLATE_USER ;
GRANT DROP ANY MATERIALIZED VIEW TO TEMPLATE_USER ;
GRANT CREATE INDEXTYPE TO TEMPLATE_USER ;
GRANT ALTER ANY SQL PROFILE TO TEMPLATE_USER ;
GRANT ALTER SYSTEM TO TEMPLATE_USER ;
GRANT CREATE MATERIALIZED VIEW TO TEMPLATE_USER ;
GRANT SELECT ANY DICTIONARY TO TEMPLATE_USER ;
GRANT DELETE ANY MEASURE FOLDER TO TEMPLATE_USER ;
GRANT DELETE ANY TABLE TO TEMPLATE_USER ;
GRANT AUDIT SYSTEM TO TEMPLATE_USER ;
GRANT ALTER ANY MATERIALIZED VIEW TO TEMPLATE_USER ;
GRANT DEBUG ANY PROCEDURE TO TEMPLATE_USER ;
GRANT CREATE ANY MEASURE FOLDER TO TEMPLATE_USER ;
GRANT COMMENT ANY TABLE TO TEMPLATE_USER ;
GRANT CREATE ANY TYPE TO TEMPLATE_USER ;
GRANT DROP ANY MEASURE FOLDER TO TEMPLATE_USER ;
GRANT CREATE CUBE TO TEMPLATE_USER ;
GRANT ALTER SESSION TO TEMPLATE_USER ;
GRANT ADMINISTER DATABASE TRIGGER TO TEMPLATE_USER ;
GRANT AUDIT ANY TO TEMPLATE_USER ;