-
Notifications
You must be signed in to change notification settings - Fork 0
/
Oracle-IIDR-Schema
112 lines (95 loc) · 3.63 KB
/
Oracle-IIDR-Schema
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
--This script does not grant dba to the cdc user.
-- create user
-- CREATE user gsiidr identified by <password>
-- default tablespace <tablespace_name> temporary tablespace <temporary_tablespace_name>;
-- Grant basic roles
grant connect to gsiidr;
grant resource to gsiidr;
grant select_catalog_role to gsiidr;
grant unlimited tablespace to gsiidr;
-- Table DDL permissions
grant create any table to gsiidr;
grant alter any table to gsiidr;
grant drop any table to gsiidr;
grant lock any table to gsiidr;
-- Table DML permissions
grant select any table to gsiidr;
grant flashback any table to gsiidr;
grant insert any table to gsiidr;
grant update any table to gsiidr;
grant delete any table to gsiidr;
-- Index and view DDL permissions
grant create any index to gsiidr;
grant alter any index to gsiidr;
grant drop any index to gsiidr;
grant create any view to gsiidr;
grant drop any view to gsiidr;
-- Trigger DDL and DML permissions (only required for CDC Trigger-based)
grant create any trigger to gsiidr;
grant alter any trigger to gsiidr;
grant drop any trigger to gsiidr;
-- Sequence DDL and DML permissions (only required for CDC Trigger-based)
grant create any sequence to gsiidr;
grant select any sequence to gsiidr;
-- Procedure permissions
grant create any procedure to gsiidr;
grant execute any procedure to gsiidr;
-- Permission to perform select on the v_$ tables
grant select any dictionary to gsiidr;
-- General system views
grant select on sys.v_$database to gsiidr;
grant select on sys.v_$controlfile to gsiidr;
grant select on sys.v_$version to gsiidr;
grant select on sys.nls_database_parameters to gsiidr;
-- Archive and redo logs
grant select on sys.v_$log to gsiidr;
grant select on sys.v_$logfile to gsiidr;
grant select on sys.v_$archived_log to gsiidr;
grant select on sys.v_$log_history to gsiidr;
-- Sessions and transactions
grant alter session to gsiidr;
grant select on sys.v_$session to gsiidr;
grant select on sys.gv_$session to gsiidr;
grant select on sys.v_$transaction to gsiidr;
grant select on sys.v_$mystat to gsiidr;
-- Tables, indexes, columns and related views
grant select on sys.all_coll_types to gsiidr;
grant select on sys.all_type_attrs to gsiidr;
grant select on sys.dba_tables to gsiidr;
grant select on sys.dba_tab_comments to gsiidr;
grant select on sys.dba_tab_columns to gsiidr;
grant select on sys.dba_col_comments to gsiidr;
grant select on sys.dba_indexes to gsiidr;
grant select on sys.dba_ind_columns to gsiidr;
grant select on sys.all_constraints to gsiidr;
grant select on sys.dba_constraints to gsiidr;
grant select on sys.all_cons_columns to gsiidr;
grant select on sys.dba_cons_columns to gsiidr;
grant select on sys.tab$ to gsiidr;
grant select on sys.ind$ to gsiidr;
grant select on sys.lob$ to gsiidr;
grant select on sys.col$ to gsiidr;
grant select on sys.icol$ to gsiidr;
grant select on sys.coltype$ to gsiidr;
grant select on sys.attrcol$ to gsiidr;
grant select on sys.ccol$ to gsiidr;
grant select on sys.cdef$ to gsiidr;
-- Miscellaneous other objects
grant select on sys.obj$ to gsiidr;
grant select on sys.dba_mviews to gsiidr;
grant select on sys.dba_objects to gsiidr;
grant select on sys.dba_sequences to gsiidr;
grant select on sys.hist_head$ to gsiidr;
grant select on sys.resource_cost to gsiidr;
-- Storage
grant select on sys.dba_tablespaces to gsiidr;
grant select on sys.dba_rollback_segs to gsiidr;
-- Permissions
grant select on sys.dba_users to gsiidr;
grant select on sys.dba_sys_privs to gsiidr;
grant select on sys.dba_tab_privs to gsiidr;
grant select on sys.dba_profiles to gsiidr;
grant select on sys.dba_roles to gsiidr;
grant select on sys.user$ to gsiidr;
grant select on user_role_privs to gsiidr;
exit;