oracle规定:resource角色会把unlimited tablespace权限授予用户,而oracle则允许具备这一个权限的用户可以在不是自己的默认表空间里创建对象,即使该用户在该表空间里没有空间配额(quote): 执行:select * from dba_sys_privs where grantee='RESOURCE';显示如下: GRANTEE PRIVILEGE ADM ------------------------------ ---------------------------------------- --- CONNECT CREATE DATABASE LINK NO RESOURCE CREATE TYPE NO RESOURCE CREATE TABLE NO RESOURCE CREATE CLUSTER NO RESOURCE CREATE TRIGGER NO RESOURCE CREATE OPERATOR NO RESOURCE CREATE SEQUENCE NO RESOURCE CREATE INDEXTYPE NO RESOURCE CREATE PROCEDURE NO 上面是该角色所具有的系统级权限
执行:select * from dba_sys_privs where grantee='RESOURCE';显示如下:
GRANTEE PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
CONNECT CREATE DATABASE LINK NO
RESOURCE CREATE TYPE NO
RESOURCE CREATE TABLE NO
RESOURCE CREATE CLUSTER NO
RESOURCE CREATE TRIGGER NO
RESOURCE CREATE OPERATOR NO
RESOURCE CREATE SEQUENCE NO
RESOURCE CREATE INDEXTYPE NO
RESOURCE CREATE PROCEDURE NO
上面是该角色所具有的系统级权限