我创建了一个新用户,并给用户授权CONNECT,RESOURCE,后来运行存储过程A,该存储过程中调用创建表的存储过程B和创建视图的存储过程,运行出错,报没有足够权限,后来单独运行
grant create table,create view to user;
就可以执行了
问题:
connect,resource 角色包括了create table,create view权限(如下),为什么报权限不够,单独加上这两个权限就可以了?
SQL> L
1* select * from role_sys_privs where role in('RESOURCE','CONNECT')
SQL> /
ROLE
PRIVILEGE
ADM
------------------------------ ---------------------------------------- ---
CONNECT
CREATE VIEW
NO
CONNECT
CREATE TABLE
NO
CONNECT
ALTER SESSION
NO
CONNECT
CREATE CLUSTER
NO
CONNECT
CREATE SESSION
NO
CONNECT
CREATE SYNONYM
NO
CONNECT
CREATE SEQUENCE
NO
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