重庆思庄Oracle、Redhat认证学习论坛

标题: oracle 12c取消resource角色中的UNLIMITED TABLESPACE权限 [打印本页]

作者: miss_puff 时间: 2018-1-16 10:38
标题: oracle 12c取消resource角色中的UNLIMITED TABLESPACE权限
说明：在 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>

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)