授权: create user tempUser identified by sa default tablespace users temporary tablespace temp quota unlimited on users; create profile tempprofile LIMIT SESSIONS_PER_USER 3 CPU_PER_CALL 2000 IDLE_TIME 15 LOGICAL_READS_PER_CALL 200 FAILED_LOGIN_ATTEMPTS 2; --为用户指定配置文件 alter user tempUser profile tempprofile; --为用户授的权限 grant create session to tempUser; grant select on student to tempUser; connect tempUser/sa; --撤销用户权限 revoke select on system.student from tempUser; revoke create session from tempUser; create user tempUser identified by sa de 你的当前访问异常,请进行认证后继续阅读剩余内容。 提交