如何在数据字典中取得下面这样的权限一览呢?
object Select Insert Update Delete References Alter Index Execute ReadA(fuction) Yes
C(procedure) Yes
B(table) Yes Yes Yes Yes
...
...
object Select Insert Update Delete References Alter Index Execute ReadA(fuction) Yes
C(procedure) Yes
B(table) Yes Yes Yes Yes
...
...
查询该user下所有对象的上述权限吗?
我觉得,区分查询:
1.系统权限
user_sys_privs
2.对象权限
user_tab_privs
3.拥有的对象
user_objects
因该可以满足了