GRANT CREATE ANY TRIGGER TO ST_USER GRANT UPDATE ANY TABLE TO ST_USER

 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
GRANT CREATE ANY TRIGGER TO ST_USER;
GRANT UPDATE ANY TABLE TO ST_USER;
GRANT CREATE USER TO ST_USER;
GRANT RESTRICTED SESSION TO ST_USER;
GRANT DROP PROFILE TO ST_USER;
GRANT ALTER ANY TRIGGER TO ST_USER;
GRANT FORCE ANY TRANSACTION TO ST_USER;
GRANT CREATE ROLE TO ST_USER;
GRANT DROP PUBLIC DATABASE LINK TO ST_USER;
GRANT CREATE VIEW TO ST_USER;
GRANT INSERT ANY TABLE TO ST_USER;
GRANT CREATE TABLE TO ST_USER;
GRANT ALTER ROLLBACK SEGMENT TO ST_USER;
GRANT DROP TABLESPACE TO ST_USER;
GRANT ALTER TABLESPACE TO ST_USER;
GRANT CREATE ANY MATERIALIZED VIEW TO ST_USER;
GRANT ANALYZE ANY TO ST_USER;
GRANT DROP ANY PROCEDURE TO ST_USER;
GRANT CREATE ANY PROCEDURE TO ST_USER;
GRANT DROP ANY ROLE TO ST_USER;
GRANT CREATE ANY SEQUENCE TO ST_USER;
GRANT DROP ANY SYNONYM TO ST_USER;
GRANT CREATE ANY SYNONYM TO ST_USER;
GRANT CREATE ANY CLUSTER TO ST_USER;
GRANT SELECT ANY TABLE TO ST_USER;
GRANT AUDIT SYSTEM TO ST_USER;
GRANT GRANT ANY PRIVILEGE TO ST_USER;
GRANT ALTER RESOURCE COST TO ST_USER;
GRANT DROP ANY TRIGGER TO ST_USER;
GRANT EXECUTE ANY PROCEDURE TO ST_USER;
GRANT CREATE DATABASE LINK TO ST_USER;
GRANT DROP ANY SEQUENCE TO ST_USER;
GRANT CREATE SEQUENCE TO ST_USER;
GRANT CREATE SYNONYM TO ST_USER;
GRANT ALTER ANY INDEX TO ST_USER;
GRANT CREATE ANY INDEX TO ST_USER;
GRANT DROP ANY CLUSTER TO ST_USER;
GRANT LOCK ANY TABLE TO ST_USER;
GRANT DROP ANY TABLE TO ST_USER;
GRANT DROP ROLLBACK SEGMENT TO ST_USER;
GRANT ALTER SESSION TO ST_USER;
GRANT CREATE SESSION TO ST_USER;
GRANT ALTER ANY PROCEDURE TO ST_USER;
GRANT FORCE TRANSACTION TO ST_USER;
GRANT AUDIT ANY TO ST_USER;
GRANT ALTER ANY ROLE TO ST_USER;
GRANT GRANT ANY ROLE TO ST_USER;
GRANT DROP ANY VIEW TO ST_USER;
GRANT DROP PUBLIC SYNONYM TO ST_USER;
GRANT CREATE PUBLIC SYNONYM TO ST_USER;
GRANT CREATE ANY TABLE TO ST_USER;
GRANT ALTER SYSTEM TO ST_USER;
GRANT DROP ANY MATERIALIZED VIEW TO ST_USER;
GRANT ALTER ANY MATERIALIZED VIEW TO ST_USER;
GRANT CREATE TRIGGER TO ST_USER;
GRANT ALTER DATABASE TO ST_USER;
GRANT CREATE PUBLIC DATABASE LINK TO ST_USER;
GRANT DROP ANY INDEX TO ST_USER;
GRANT DELETE ANY TABLE TO ST_USER;
GRANT COMMENT ANY TABLE TO ST_USER;
GRANT CREATE ROLLBACK SEGMENT TO ST_USER;
GRANT SELECT ANY DICTIONARY TO ST_USER;
GRANT CREATE PROFILE TO ST_USER;
GRANT CREATE PROCEDURE TO ST_USER;
GRANT CREATE ANY VIEW TO ST_USER;
GRANT BACKUP ANY TABLE TO ST_USER;
GRANT ALTER ANY TABLE TO ST_USER;
GRANT DROP USER TO ST_USER;
GRANT ALTER USER TO ST_USER;
GRANT BECOME USER TO ST_USER;
GRANT UNLIMITED TABLESPACE TO ST_USER;
GRANT CREATE MATERIALIZED VIEW TO ST_USER;
GRANT ALTER PROFILE TO ST_USER;
GRANT SELECT ANY SEQUENCE TO ST_USER;
GRANT ALTER ANY SEQUENCE TO ST_USER;
GRANT ALTER ANY CLUSTER TO ST_USER;
GRANT CREATE CLUSTER TO ST_USER;
GRANT MANAGE TABLESPACE TO ST_USER;
GRANT CREATE TABLESPACE TO ST_USER;
-- 6 Object Privileges for ST_USER
GRANT SELECT ON MTR.IMTR_CASE TO ST_USER;
GRANT ALTER, INSERT, SELECT, UPDATE ON REESTR_L.TYPE_O_BUFF TO ST_USER;
GRANT SELECT ON SYS.OBJ$ TO ST_USER;
GRANT SELECT ON SYS.USER$ TO ST_USER;
GRANT SELECT ON SYS.V_$MYSTAT TO ST_USER;
GRANT SELECT ON SYS.V_$SESSION TO ST_USER;