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