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