------------------------------------------------ --创建用户_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;