oracle 12c取消resource角色中的UNLIMITED TABLESPACE权限

miss_puff

说明：在 oracle 12c中，给用户授予resource角色，取消了unlimited tablespace权限。

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 RACDBPDB                       READ WRITE NO
SQL> alter session set container=racdbpdb;

Session altered.

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         3 RACDBPDB                       READ WRITE NO
SQL> create user sztech identified by sztech;

User created.

SQL> grant connect,resource to sztech;

Grant succeeded.

SQL>



SQL> conn sztech/sztech@racdbpdb
Connected.
SQL> show con_name;

CON_NAME
------------------------------
RACDBPDB
SQL>  select * from session_privs;


PRIVILEGE
--------------------------------------------------------------------------------
SET CONTAINER
CREATE INDEXTYPE
CREATE OPERATOR
CREATE TYPE
CREATE TRIGGER
CREATE PROCEDURE
CREATE SEQUENCE
CREATE CLUSTER
CREATE TABLE
CREATE SESSION

10 rows selected.

SQL>