-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathPermissions.sql
237 lines (180 loc) · 9.26 KB
/
Permissions.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
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
CREATE USER SAI IDENTIFIED BY SAI123;
CREATE USER SHREY IDENTIFIED BY SHR123;
CREATE USER SARTHAK IDENTIFIED BY SAR123;
CREATE USER MICHEAL IDENTIFIED BY MIC456;
CREATE USER RACHEAL IDENTIFIED BY RAC456;
CREATE USER KHUSHI IDENTIFIED BY KHU456;
CREATE USER PARTHVI IDENTIFIED BY PAR789;
CREATE USER LUCIFER IDENTIFIED BY LUC789;
CREATE USER SHIRLEY IDENTIFIED BY SHI789;
CREATE USER LAUREN IDENTIFIED BY LAU012;
CREATE USER MARTHA IDENTIFIED BY MAR012;
CREATE USER JEREMY IDENTIFIED BY JER012;
CREATE USER GABRIEL IDENTIFIED BY GAB345;
CREATE USER SOPHIA IDENTIFIED BY SOP345;
GRANT CREATE SESSION TO SAI;
GRANT CREATE SESSION TO SHREY;
GRANT CREATE SESSION TO SARTHAK;
GRANT CREATE SESSION TO MICHEAL;
GRANT CREATE SESSION TO RACHEAL;
GRANT CREATE SESSION TO KHUSHI;
GRANT CREATE SESSION TO PARTHVI;
GRANT CREATE SESSION TO LUCIFER;
GRANT CREATE SESSION TO SHIRLEY;
GRANT CREATE SESSION TO LAUREN;
GRANT CREATE SESSION TO MARTHA;
GRANT CREATE SESSION TO JEREMY;
GRANT CREATE SESSION TO GABRIEL;
GRANT CREATE SESSION TO SOPHIA;
GRANT dba TO SAI;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.USERS TO SAI;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.USER_PHONE TO SAI;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.LOGIN TO SAI;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROPERTY TO SAI;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROP_OWNED TO SAI;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROP_RENTED TO SAI;
GRANT SELECT, UPDATE ON SYS.USERS TO SAI;
GRANT SELECT, DELETE, INSERT, UPDATE ON SYS.USER_PHONE TO SAI;
GRANT SELECT, UPDATE ON SYS.LOGIN TO SAI;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROPERTY TO SAI;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROP_OWNED TO SAI;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROP_RENTED TO SAI;
GRANT SELECT, UPDATE ON SYS.USERS TO SHREY;
GRANT SELECT, DELETE, INSERT, UPDATE ON SYS.USER_PHONE TO SHREY;
GRANT SELECT, UPDATE ON SYS.LOGIN TO SHREY;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROPERTY TO SHREY;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROP_OWNED TO SHREY;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROP_RENTED TO SHREY;
GRANT SELECT, UPDATE ON SYS.USERS TO SARTHAK;
GRANT SELECT, DELETE, INSERT, UPDATE ON SYS.USER_PHONE TO SARTHAK;
GRANT SELECT, UPDATE ON SYS.LOGIN TO SARTHAK;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROPERTY TO SARTHAK;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROP_OWNED TO SARTHAK;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROP_RENTED TO SARTHAK;
GRANT SELECT, UPDATE ON SYS.USERS TO MICHEAL;
GRANT SELECT, DELETE, INSERT, UPDATE ON SYS.USER_PHONE TO MICHEAL;
GRANT SELECT, UPDATE ON SYS.LOGIN TO MICHEAL;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROPERTY TO MICHEAL;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROP_OWNED TO MICHEAL;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROP_RENTED TO MICHEAL;
GRANT SELECT, UPDATE ON SYS.USERS TO RACHEAL;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.USER_PHONE TO RACHEAL;
GRANT SELECT, UPDATE ON SYS.LOGIN TO RACHEAL;
GRANT SELECT, INSERT ON SYS.PROPERTY TO RACHEAL;
GRANT SELECT, INSERT ON SYS.PROP_OWNED TO RACHEAL;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROP_RENTED TO RACHEAL;
GRANT SELECT, UPDATE ON SYS.USERS TO KHUSHI;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.USER_PHONE TO KHUSHI;
GRANT SELECT, UPDATE ON SYS.LOGIN TO KHUSHI;
GRANT SELECT, INSERT ON SYS.PROPERTY TO KHUSHI;
GRANT SELECT, INSERT ON SYS.PROP_OWNED TO KHUSHI;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROP_RENTED TO KHUSHI;
GRANT SELECT, UPDATE ON SYS.USERS TO PARTHVI;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.USER_PHONE TO PARTHVI;
GRANT SELECT, UPDATE ON SYS.LOGIN TO PARTHVI;
GRANT SELECT, INSERT ON SYS.PROPERTY TO PARTHVI;
GRANT SELECT, INSERT ON SYS.PROP_OWNED TO PARTHVI;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROP_RENTED TO PARTHVI;
GRANT SELECT, UPDATE ON SYS.USERS TO LUCIFER;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.USER_PHONE TO LUCIFER;
GRANT SELECT, UPDATE ON SYS.LOGIN TO LUCIFER;
GRANT SELECT, INSERT ON SYS.PROPERTY TO LUCIFER;
GRANT SELECT, INSERT ON SYS.PROP_OWNED TO LUCIFER;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROP_RENTED TO LUCIFER;
GRANT SELECT, UPDATE ON SYS.USERS TO LUCIFER;
GRANT SELECT, UPDATE ON SYS.USER_PHONE TO LUCIFER;
GRANT SELECT, UPDATE ON SYS.LOGIN TO LUCIFER;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROPERTY TO LUCIFER;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROP_OWNED TO LUCIFER;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROP_RENTED TO LUCIFER;
GRANT SELECT, UPDATE ON SYS.USERS TO SHIRLEY;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.USER_PHONE TO SHIRLEY;
GRANT SELECT, UPDATE ON SYS.LOGIN TO SHIRLEY;
GRANT SELECT, INSERT ON SYS.PROPERTY TO SHIRLEY;
GRANT SELECT, INSERT ON SYS.PROP_OWNED TO SHIRLEY;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROP_RENTED TO SHIRLEY;
GRANT SELECT, UPDATE ON SYS.USERS TO SHIRLEY;
GRANT SELECT, UPDATE ON SYS.USER_PHONE TO SHIRLEY;
GRANT SELECT, UPDATE ON SYS.LOGIN TO SHIRLEY;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROPERTY TO SHIRLEY;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROP_OWNED TO SHIRLEY;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROP_RENTED TO SHIRLEY;
GRANT
SELECT, UPDATE ON SYS.USERS TO LAUREN;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.USER_PHONE TO LAUREN;
GRANT SELECT, UPDATE ON SYS.LOGIN TO LAUREN;
GRANT SELECT, INSERT ON SYS.PROPERTY TO LAUREN;
GRANT SELECT, INSERT ON SYS.PROP_OWNED TO LAUREN;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROP_RENTED TO LAUREN;
GRANT SELECT, UPDATE ON SYS.USERS TO LAUREN;
GRANT SELECT, UPDATE ON SYS.USER_PHONE TO LAUREN;
GRANT SELECT, UPDATE ON SYS.LOGIN TO LAUREN;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROPERTY TO LAUREN;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROP_OWNED TO LAUREN;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROP_RENTED TO LAUREN;
GRANT SELECT, UPDATE ON SYS.USERS TO MARTHA;
GRANT SELECT, DELETE, INSERT, UPDATE ON SYS.USER_PHONE TO MARTHA;
GRANT SELECT, UPDATE ON SYS.LOGIN TO MARTHA;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROPERTY TO MARTHA;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROP_OWNED TO MARTHA;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROP_RENTED TO MARTHA;
GRANT SELECT, UPDATE ON SYS.USERS TO MARTHA;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.USER_PHONE TO MARTHA;
GRANT SELECT, UPDATE ON SYS.LOGIN TO MARTHA;
GRANT SELECT, INSERT ON SYS.PROPERTY TO MARTHA;
GRANT SELECT, INSERT ON SYS.PROP_OWNED TO MARTHA;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROP_RENTED TO MARTHA;
GRANT SELECT, UPDATE ON SYS.USERS TO JEREMY;
GRANT SELECT, DELETE, INSERT, UPDATE ON SYS.USER_PHONE TO JEREMY;
GRANT SELECT, UPDATE ON SYS.LOGIN TO JEREMY;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROPERTY TO JEREMY;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROP_OWNED TO JEREMY;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROP_RENTED TO JEREMY;
GRANT SELECT, UPDATE ON SYS.USERS TO JEREMY;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.USER_PHONE TO JEREMY;
GRANT SELECT, UPDATE ON SYS.LOGIN TO JEREMY;
GRANT SELECT, INSERT ON SYS.PROPERTY TO JEREMY;
GRANT SELECT, INSERT ON SYS.PROP_OWNED TO JEREMY;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROP_RENTED TO JEREMY;
GRANT SELECT, UPDATE ON SYS.USERS TO GABRIEL;
GRANT SELECT, DELETE, INSERT, UPDATE ON SYS.USER_PHONE TO GABRIEL;
GRANT SELECT, UPDATE ON SYS.LOGIN TO GABRIEL;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROPERTY TO GABRIEL;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROP_OWNED TO GABRIEL;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROP_RENTED TO GABRIEL;
GRANT SELECT, UPDATE ON SYS.USERS TO GABRIEL;
GRANT SELECT, UPDATE ON SYS.USER_PHONE TO GABRIEL;
GRANT SELECT, UPDATE ON SYS.LOGIN TO GABRIEL;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROPERTY TO GABRIEL;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROP_OWNED TO GABRIEL;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROP_RENTED TO GABRIEL;
GRANT SELECT, UPDATE ON SYS.USERS TO SOPHIA;
GRANT SELECT, UPDATE ON SYS.USER_PHONE TO SOPHIA;
GRANT SELECT, UPDATE ON SYS.LOGIN TO SOPHIA;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROPERTY TO SOPHIA;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROP_OWNED TO SOPHIA;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROP_RENTED TO SOPHIA;
GRANT SELECT, UPDATE ON SYS.USERS TO SOPHIA;
GRANT SELECT, DELETE, INSERT, UPDATE ON SYS.USER_PHONE TO SOPHIA;
GRANT SELECT, UPDATE ON SYS.LOGIN TO SOPHIA;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROPERTY TO SOPHIA;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROP_OWNED TO SOPHIA;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROP_RENTED TO SOPHIA;
GRANT SELECT, UPDATE ON SYS.USERS TO SOPHIA;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.USER_PHONE TO SOPHIA;
GRANT SELECT, UPDATE ON SYS.LOGIN TO SOPHIA;
GRANT SELECT, INSERT ON SYS.PROPERTY TO SOPHIA;
GRANT SELECT, INSERT ON SYS.PROP_OWNED TO SOPHIA;
GRANT SELECT, INSERT, UPDATE, DELETE ON SYS.PROP_RENTED TO SOPHIA;
GRANT EXECUTE ON SYS.GetPropertyRecord TO SAI;
GRANT EXECUTE ON SYS.GetTenantDetails TO SAI;
GRANT EXECUTE ON SYS.SearchPropertyForRent TO SAI;
GRANT EXECUTE ON SYS.GetRentHistory TO SAI;
GRANT EXECUTE ON SYS.InsertPropertyRecord TO SAI;
GRANT EXECUTE ON SYS.CreateNewUser TO SAI;
GRANT EXECUTE ON SYS.GetPropertyRecord TO SHREY;
GRANT EXECUTE ON SYS.GetTenantDetails TO SHREY;
GRANT EXECUTE ON SYS.SearchPropertyForRent TO SHREY;
GRANT EXECUTE ON SYS.GetRentHistory TO SHREY;
GRANT EXECUTE ON SYS.InsertPropertyRecord TO SHREY;
GRANT EXECUTE ON SYS.CreateNewUser TO SHREY;