12C 创建用户授予connect+resource 后不在级联给予UNLIMITED TABLESPACE权限

来源：互联网发布：数据库设计实例编辑：程序博客网时间：2024/05/22 12:09

在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 NOYES
TEST CONNECT NOYES

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

阅读全文

0 0