143 lines
6.1 KiB
SQL
143 lines
6.1 KiB
SQL
------------------------------------------------
|
|
--创建用户_highway_storage
|
|
------------------------------------------------
|
|
create user highway_storage identified by qrwl default tablespace highway_storage temporary tablespace realestate_tempgroup profile default;
|
|
--授予角色权限
|
|
grant connect to highway_storage;
|
|
grant dba to highway_storage;
|
|
--授予系统权限
|
|
grant under any view to highway_storage;
|
|
grant select any table to highway_storage;
|
|
grant grant any role to highway_storage;
|
|
grant grant any object privilege to highway_storage;
|
|
grant execute any program to highway_storage;
|
|
grant grant any privilege to highway_storage;
|
|
grant create any procedure to highway_storage;
|
|
grant select any sequence to highway_storage;
|
|
grant create any view to highway_storage;
|
|
grant under any type to highway_storage;
|
|
grant alter any procedure to highway_storage;
|
|
grant insert any table to highway_storage;
|
|
grant unlimited tablespace to highway_storage;
|
|
grant execute any procedure to highway_storage;
|
|
grant create any table to highway_storage;
|
|
grant select any dictionary to highway_storage;
|
|
grant alter any operator to highway_storage;
|
|
grant delete any table to highway_storage;
|
|
grant update any table to highway_storage;
|
|
grant alter any table to highway_storage;
|
|
|
|
------------------------------------------------
|
|
--创建用户_highway_running
|
|
------------------------------------------------
|
|
create user highway_running identified by qrwl default tablespace highway_running temporary tablespace realestate_tempgroup profile default;
|
|
--授予角色权限
|
|
grant connect to highway_running;
|
|
grant dba to highway_running;
|
|
--授予系统权限
|
|
grant grant any object privilege to highway_running;
|
|
grant grant any privilege to highway_running;
|
|
grant execute any procedure to highway_running;
|
|
grant create any procedure to highway_running;
|
|
grant alter any table to highway_running;
|
|
grant select any sequence to highway_running;
|
|
grant create any view to highway_running;
|
|
grant delete any table to highway_running;
|
|
grant insert any table to highway_running;
|
|
grant execute any program to highway_running;
|
|
grant alter any operator to highway_running;
|
|
grant select any dictionary to highway_running;
|
|
grant alter any procedure to highway_running;
|
|
grant unlimited tablespace to highway_running;
|
|
grant grant any role to highway_running;
|
|
grant select any table to highway_running;
|
|
grant create any table to highway_running;
|
|
|
|
------------------------------------------------
|
|
--创建用户_highway_history
|
|
------------------------------------------------
|
|
create user highway_history identified by qrwl default tablespace highway_history temporary tablespace realestate_tempgroup profile default;
|
|
--授予角色权限
|
|
grant connect to highway_history;
|
|
grant dba to highway_history;
|
|
--授予系统权限
|
|
grant alter any operator to highway_history;
|
|
grant grant any privilege to highway_history;
|
|
grant execute any program to highway_history;
|
|
grant create any view to highway_history;
|
|
grant under any type to highway_history;
|
|
grant select any table to highway_history;
|
|
grant select any sequence to highway_history;
|
|
grant delete any table to highway_history;
|
|
grant grant any role to highway_history;
|
|
grant create any table to highway_history;
|
|
grant select any dictionary to highway_history;
|
|
grant create any procedure to highway_history;
|
|
grant insert any table to highway_history;
|
|
grant unlimited tablespace to highway_history;
|
|
grant alter any procedure to highway_history;
|
|
grant grant any object privilege to highway_history;
|
|
grant under any view to highway_history;
|
|
grant execute any procedure to highway_history;
|
|
grant update any table to highway_history;
|
|
grant alter any table to highway_history;
|
|
|
|
------------------------------------------------
|
|
--创建用户_highway_selldata
|
|
------------------------------------------------
|
|
create user highway_selldata identified by qrwl default tablespace highway_selldata temporary tablespace realestate_tempgroup profile default;
|
|
--授予角色权限
|
|
grant dba to highway_selldata;
|
|
grant connect to highway_selldata;
|
|
--授予系统权限
|
|
grant unlimited tablespace to highway_selldata;
|
|
grant grant any object privilege to highway_selldata;
|
|
grant select any dictionary to highway_selldata;
|
|
grant delete any table to highway_selldata;
|
|
grant select any table to highway_selldata;
|
|
grant alter any operator to highway_selldata;
|
|
grant grant any privilege to highway_selldata;
|
|
grant alter any procedure to highway_selldata;
|
|
grant execute any program to highway_selldata;
|
|
grant select any sequence to highway_selldata;
|
|
grant insert any table to highway_selldata;
|
|
grant grant any role to highway_selldata;
|
|
grant create any view to highway_selldata;
|
|
grant update any table to highway_selldata;
|
|
grant create any table to highway_selldata;
|
|
grant alter any table to highway_selldata;
|
|
grant under any view to highway_selldata;
|
|
grant create any procedure to highway_selldata;
|
|
grant under any type to highway_selldata;
|
|
grant execute any procedure to highway_selldata;
|
|
|
|
------------------------------------------------
|
|
--创建用户_highway_exchange
|
|
------------------------------------------------
|
|
create user highway_exchange identified by qrwl default tablespace highway_exchange temporary tablespace realestate_tempgroup profile default;
|
|
--授予角色权限
|
|
grant connect to highway_exchange;
|
|
grant dba to highway_exchange;
|
|
--授予系统权限
|
|
grant under any view to highway_exchange;
|
|
grant grant any role to highway_exchange;
|
|
grant create any view to highway_exchange;
|
|
grant execute any program to highway_exchange;
|
|
grant create any procedure to highway_exchange;
|
|
grant update any table to highway_exchange;
|
|
grant insert any table to highway_exchange;
|
|
grant select any table to highway_exchange;
|
|
grant select any dictionary to highway_exchange;
|
|
grant alter any procedure to highway_exchange;
|
|
grant delete any table to highway_exchange;
|
|
grant grant any privilege to highway_exchange;
|
|
grant select any sequence to highway_exchange;
|
|
grant grant any object privilege to highway_exchange;
|
|
grant under any type to highway_exchange;
|
|
grant execute any procedure to highway_exchange;
|
|
grant create any table to highway_exchange;
|
|
grant alter any operator to highway_exchange;
|
|
grant alter any table to highway_exchange;
|
|
grant unlimited tablespace to highway_exchange;
|
|
|