RESOURCE、DBA角色与UNLIMITED TABLESPACE权限关系.docVIP

RESOURCE、DBA角色与UNLIMITED TABLESPACE权限关系 RESOURCE、DBA角色与UNLIMITED TABLESPACE权限关系 如果在对用户赋权时赋予了DBA或者RESOURCE角色，那么该用户会自动被赋予UNLIMITED TABLESPACE系统权限。如果要撤销上述角色的话，也会导致UNLIMITED TABLESPACE系统权限被撤销。当然，UNLIMITED TABLESPACE权限也可以被单独撤销。 SQLshow user USER is SYS SQLcreate user t identified by t; User created. SQLgrant connect to t; Grant succeeded. SQLconn t/t Connected. SQLselect * from session_privs; PRIVILEGE ---------------------------------------- CREATE SESSION SQLconn / as sysdba Connected. SQLgrant resource to t; Grant succeeded. SQLconn t/t Connected. SQLselect * from session_privs; PRIVILEGE ---------------------------------------- CREATE SESSION UNLIMITED TABLESPACE CREATE TABLE CREATE CLUSTER CREATE SEQUENCE CREATE PROCEDURE CREATE TRIGGER CREATE TYPE CREATE OPERATOR CREATE INDEXTYPE 10 rows selected. SQLconn / as sysdba Connected. SQLselect * from dba_sys_privs where grantee=RESOURCE; GRANTEE PRIVILEGE ADMIN_OPTION ------------------------------ ------------------------------- ------------------------ RESOURCE CREATE TRIGGER NO RESOURCE CREATE SEQUENCE NO RESOURCE CREATE TYPE NO RESOURCE CREATE PROCEDURE NO RESOURCE CREATE CLUSTER NO RESOURCE CREATE OPERATOR NO RESOURCE CREATE INDEXTYPE NO RESOURCE CREATE TABLE NO 8 rows selected. SQLrevoke resource from t; Revoke succeeded. SQLconn t/t Connected. SQLselect * from session_privs; PRIVILEGE ---------------------------------------- CREATE SESSION SQLconn / as sysdba Connected. SQLgrant dba to t; Grant succeeded. SQLconn t/t Connected. SQLselect * from session_privs; PRIVILEGE ---------------------------------------- ALTER SYSTEM AUD