| 51 |
mhunt |
1 |
create user release_manager identified by release_manager;
|
|
|
2 |
create user archive_manager identified by archive_manager;
|
|
|
3 |
create user access_manager identified by access_manager;
|
|
|
4 |
create user deployment_manager identified by deployment_manager;
|
|
|
5 |
grant select any table to release_manager;
|
|
|
6 |
grant insert any table to release_manager;
|
|
|
7 |
grant update any table to release_manager;
|
|
|
8 |
grant delete any table to release_manager;
|
|
|
9 |
grant select any table to archive_manager;
|
|
|
10 |
grant insert any table to archive_manager;
|
|
|
11 |
grant update any table to archive_manager;
|
|
|
12 |
grant delete any table to archive_manager;
|
|
|
13 |
grant select any table to access_manager;
|
|
|
14 |
grant insert any table to access_manager;
|
|
|
15 |
grant update any table to access_manager;
|
|
|
16 |
grant delete any table to access_manager;
|
|
|
17 |
grant select any table to deployment_manager;
|
|
|
18 |
grant insert any table to deployment_manager;
|
|
|
19 |
grant update any table to deployment_manager;
|
|
|
20 |
grant delete any table to deployment_manager;
|
|
|
21 |
grant select any sequence to release_manager;
|
|
|
22 |
grant select any sequence to archive_manager;
|
|
|
23 |
grant select any sequence to access_manager;
|
|
|
24 |
grant select any sequence to deployment_manager;
|
|
|
25 |
grant execute any procedure to release_manager;
|
|
|
26 |
grant execute any procedure to archive_manager;
|
|
|
27 |
grant execute any procedure to access_manager;
|
|
|
28 |
grant execute any procedure to deployment_manager;
|