确定ORACLE会话的访问对象类型及数量

1 确定HR模式中各种类型的对象数量

此处为HR所拥有的对象：user_objects
SQL> select object_type,count(*) from user_objects group by object_type;

OBJECT_TYPE           COUNT(*)
------------------- ----------
SEQUENCE                     3
PROCEDURE                    2
TRIGGER                      2
TABLE                        8
INDEX                       19
VIEW                         1

2 确定HR有权访问的对象总数

select object_type,count(*) from all_objects group by object_type;

OBJECT_TYPE           COUNT(*)
------------------- ----------
SEQUENCE                     3
PROCEDURE                    2
TRIGGER                      2
TABLE                        8
INDEX                       19
VIEW                         1

。。。。。。。。。。
。。。。。。。。。。

3 确定HR能看到的对象都归谁

SQL> select distinct owner from all_objects;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/20399666/viewspace-703375/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/20399666/viewspace-703375/