-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathUSA_USER.sql
More file actions
48 lines (40 loc) · 1.69 KB
/
USA_USER.sql
File metadata and controls
48 lines (40 loc) · 1.69 KB
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
Create user ORSUSER_USA identified by ORSUSER_USA default tablespace ORSUSER_USA_DAT;
GRANT "CONNECT" TO "ORSUSER_USA";
ALTER USER "ORSUSER_USA" DEFAULT ROLE ALL;
GRANT ALTER ANY INDEX TO "ORSUSER_USA";
GRANT ALTER ANY INDEXTYPE TO "ORSUSER_USA";
GRANT ALTER ANY SEQUENCE TO "ORSUSER_USA";
GRANT CREATE ANY INDEX TO "ORSUSER_USA";
GRANT CREATE ANY INDEXTYPE TO "ORSUSER_USA";
GRANT CREATE ANY PROCEDURE TO "ORSUSER_USA";
GRANT CREATE ANY SEQUENCE TO "ORSUSER_USA";
GRANT CREATE ANY TABLE TO "ORSUSER_USA";
GRANT CREATE ANY TRIGGER TO "ORSUSER_USA";
GRANT CREATE ANY VIEW TO "ORSUSER_USA";
GRANT CREATE PROCEDURE TO "ORSUSER_USA";
GRANT CREATE ROLLBACK SEGMENT TO "ORSUSER_USA";
GRANT CREATE TRIGGER TO "ORSUSER_USA";
GRANT CREATE VIEW TO "ORSUSER_USA";
GRANT DEBUG ANY PROCEDURE TO "ORSUSER_USA";
GRANT DELETE ANY TABLE TO "ORSUSER_USA";
GRANT DROP ANY INDEX TO "ORSUSER_USA";
GRANT DROP ANY INDEXTYPE TO "ORSUSER_USA";
GRANT DROP ANY LIBRARY TO "ORSUSER_USA";
GRANT DROP ANY PROCEDURE TO "ORSUSER_USA";
GRANT DROP ANY SEQUENCE TO "ORSUSER_USA";
GRANT DROP ANY TABLE TO "ORSUSER_USA";
GRANT EXECUTE ANY INDEXTYPE TO "ORSUSER_USA";
GRANT EXECUTE ANY LIBRARY TO "ORSUSER_USA";
GRANT EXECUTE ANY PROCEDURE TO "ORSUSER_USA";
GRANT INSERT ANY TABLE TO "ORSUSER_USA";
GRANT SELECT ANY DICTIONARY TO "ORSUSER_USA";
GRANT SELECT ANY SEQUENCE TO "ORSUSER_USA";
GRANT SELECT ANY TABLE TO "ORSUSER_USA";
GRANT UNDER ANY TABLE TO "ORSUSER_USA";
GRANT UNDER ANY VIEW TO "ORSUSER_USA";
GRANT UPDATE ANY TABLE TO "ORSUSER_USA";
GRANT UNLIMITED TABLESPACE TO "ORSUSER_USA";
GRANT RESOURCE TO "ORSUSER_USA";
GRANT DEBUG ANY PROCEDURE, DEBUG CONNECT SESSION TO ORSUSER_USA;
GRANT IMP_FULL_DATABASE TO ORSUSER_USA;
GRANT DBA TO ORSUSER_USA;