Oracle 角色的两个特性和误区(二)

2014-11-24 18:36:42 · 作者: · 浏览: 1
5:16 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

idle> conn scott/oracle
Connected.
scott@ORCL> select GRANTED_ROLE,DEFAULT_ROLE from user_role_privs;

GRANTED_ROLE DEF
------------------------------ ---
CONNECT YES
R1 YES

scott@ORCL> select * from hr.t;

NAME
--------------------
think