resource角色到底有些什么权限

发布网友发布时间：2022-04-14 01:31

共1个回答

热心网友时间：2022-04-14 03:00

1.CONNECT 的默认权限:ALTER SESSION CREATE CLUSTER CREATE DATABASE LINK CREATE SEQUENCE CREATE SESSION CREATE SYNONYM CREATE TABLE CREATE VIEW2.RESOURCE 的默认权限:CREATE CLUSTER CREATE INDEXTYPE CREATE OPERATOR CREATE PROCEDURE CREATE SEQUENCE CREATE TABLE CREATE TRIGGER CREATE TYPE3.对于上面的角色的权限,其实可以通过以下SQL语句可以查到:select privilege from dba_sys_privs where grantee like \'CONNECT\'select privilege from dba_sys_privs where grantee like \'RESOURCE\'当然,通过这个语句,也可以查其他系统预定义角色的权限,比如DBA的权限:select privilege from dba_sys_privs where grantee like \'DBA\'ADMINISTER DATABASE TRIGGER ADMINISTER RESOURCE MANAGER ALTER ANY CLUSTER ALTER AN......SELECT * FROM ROLE_SYS_PRIVS WHERE ROLE = 'RESOURCE';alter user SCOTT quota unlimited on users;