-- 创建用户 create user bhrs2mis identified by bhrs2mis default tablespace USERS temporary tablespace TEMP profile DEFAULT; -- 分配权限 grant connect to bhrs2mis; grant resource to bhrs2mis; grant dba to bhrs2mis; grant select on tousu_uat.x_appeal to bhrs2mis