57 lines
2.6 KiB
SQL
57 lines
2.6 KiB
SQL
------------------------------------------------
|
|
--创建用户_maintenance_storage
|
|
------------------------------------------------
|
|
create user maintenance_storage identified by qrwl default tablespace maintenance_storage temporary tablespace platform_tempgroup profile default;
|
|
--授予角色权限
|
|
grant connect to maintenance_storage;
|
|
grant dba to maintenance_storage;
|
|
--授予系统权限
|
|
grant select any dictionary to maintenance_storage;
|
|
grant grant any privilege to maintenance_storage;
|
|
grant update any table to maintenance_storage;
|
|
grant insert any table to maintenance_storage;
|
|
grant alter any operator to maintenance_storage;
|
|
grant select any sequence to maintenance_storage;
|
|
grant execute any program to maintenance_storage;
|
|
grant create any procedure to maintenance_storage;
|
|
grant under any type to maintenance_storage;
|
|
grant grant any role to maintenance_storage;
|
|
grant create any view to maintenance_storage;
|
|
grant unlimited tablespace to maintenance_storage;
|
|
grant under any view to maintenance_storage;
|
|
grant delete any table to maintenance_storage;
|
|
grant grant any object privilege to maintenance_storage;
|
|
grant select any table to maintenance_storage;
|
|
grant alter any table to maintenance_storage;
|
|
grant create any table to maintenance_storage;
|
|
grant execute any procedure to maintenance_storage;
|
|
grant alter any procedure to maintenance_storage;
|
|
|
|
------------------------------------------------
|
|
--创建用户_mainother_storage
|
|
------------------------------------------------
|
|
create user mainother_storage identified by qrwl default tablespace mainother_storage temporary tablespace platform_tempgroup profile default;
|
|
--授予角色权限
|
|
grant connect to mainother_storage;
|
|
grant dba to mainother_storage;
|
|
--授予系统权限
|
|
grant insert any table to mainother_storage;
|
|
grant create any procedure to mainother_storage;
|
|
grant delete any table to mainother_storage;
|
|
grant alter any table to mainother_storage;
|
|
grant execute any program to mainother_storage;
|
|
grant grant any privilege to mainother_storage;
|
|
grant select any table to mainother_storage;
|
|
grant unlimited tablespace to mainother_storage;
|
|
grant select any dictionary to mainother_storage;
|
|
grant under any view to mainother_storage;
|
|
grant alter any operator to mainother_storage;
|
|
grant alter any procedure to mainother_storage;
|
|
grant grant any role to mainother_storage;
|
|
grant create any table to mainother_storage;
|
|
grant grant any object privilege to mainother_storage;
|
|
grant under any type to mainother_storage;
|
|
grant execute any procedure to mainother_storage;
|
|
grant select any sequence to mainother_storage;
|
|
grant create any view to mainother_storage;
|
|
grant update any table to mainother_storage; |