需要单独授权，创建用户的步骤没有什么特殊地方。
create user “TEST” identified by “密码”;

grant “PUBLIC”,“RESOURCE”,“SOI”,“VTI” to “TEST”;

–授权查询其他模式下所有表
DECLARE
SQLSTMT STRING;
CURSOR CUR FOR SELECT ID,NAME FROM SYSOBJECTS WHERE TYPE$ = ‘SCHOBJ’ AND SUBTYPE$ IN (‘STAB’,‘UTAB’) AND (PID=-1 OR PID=0) AND SCHID=(SELECT ID FROM SYSOBJECTS WHERE TYPE$=‘SCH’ AND NAME=‘模式名’ );
TYPE MYREC IS CUR%ROWTYPE;
REC_V MYREC;
BEGIN
FOR REC_V IN CUR LOOP
SQLSTMT = ‘grant SELECT ON “模式名”."’|| REC_V.NAME || ‘" TO “TEST”;’;
EXECUTE IMMEDIATE SQLSTMT;
END LOOP;
COMMIT;
END;

创建用户时做权限管理，将需要用的对象权限勾选上就可以，角色不要勾选DBA，勾选DBA角色会对所有对象都可操作。