创建了一个user1用户,给它授予了角色connect,resource,并可传递
如:
-- Grant/Revoke role privileges
grant connect to USER1 with admin option;
grant resource to USER1 with admin option;授予系统权限:
-- Grant/Revoke system privileges
grant create session to USER1 with admin option;
grant create user to USER1 ;
grant drop user to USER1;
用user1创建用户user11,授予角色resource时就报错,说没有权限??????这是为什么呢
如:
-- Grant/Revoke role privileges
grant connect to USER1 with admin option;
grant resource to USER1 with admin option;授予系统权限:
-- Grant/Revoke system privileges
grant create session to USER1 with admin option;
grant create user to USER1 ;
grant drop user to USER1;
用user1创建用户user11,授予角色resource时就报错,说没有权限??????这是为什么呢
http://hi.baidu.com/blackbear008/blog/item/cb76a6d185530a329a50277e.html
可能你当前用户无传递RESOURCE的权限
你给USER1授权的时候没有成功
你用查看角色所包含的角色语句
select * from role_sys_privs
是否USER1是否拥有RESOURCE角色
SQL> select * from user_role_privs;Oracle 用户及角色 介绍
http://blog.csdn.net/tianlesoftware/archive/2009/11/09/4786956.aspx------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716
USERNAME GRANTED_ROLE ADMIN_OPTION DEFAULT_ROLE OS_GRANTED
------------------------------ ------------------------------ ------------ ------------ ----------
COMPANY1_USER1 CONNECT YES YES NO
COMPANY1_USER1 RESOURCE YES YES NO
SQL>