12C 创建用户授予connect+resource 后不在级联给予UNLIMITED TABLESPACE权限
在11g创建用户后权限的给予 :
SQL> create user test identified by test;
User created.
SQL> grant connect,resource to test;
Grant succeeded.
SQL> select * from dba_ROLE_PRIVS WHERE GRANTEE='TEST';
GRANTEE GRANTED_ROLE ADMIN_ DEFAUL
------------------------------------------------------------ ----------------------------- ------ ------
TEST RESOURCE NO YES
TEST CONNECT NO YES
SQL> select * From dba_sys_privs where grantee='TEST';
GRANTEE PRIVILEGE ADMIN_
--------------------------------- ---------------------------------------------------------- ------
TEST UNLIMITED TABLESPACE NO
在12.2.0.1版本
SYS@PROD> create user ORATT identified by ORATT;
User created.
SYS@PROD> grant connect,resource to ORATT;
Grant succeeded.
SYS@PROD> select *from dba_role_privs where grantee='ORATT';
GRANTEE GRANTED_ROLE ADM DEL DEF COM INH
-------------------- -------------------------------------------------------------------------------------------------------------------------------- --- --- --- --- ---
ORATT CONNECT NO NO YES NO NO
ORATT RESOURCE NO NO YES NO NO
SYS@PROD> SELECT * FROM DBA_SYS_PRIVS WHERE GRANTEE='ORATT';
GRANTEE PRIVILEGE ADM COM INH
-------------------- ---------------------------------------- --- --- ---
ORATT CREATE SESSION NO NO NO