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