DBA_SYS_PRIVS:分配给所有用户的system权限
SESSION_PRIVS:当前对所有用户有效的权限
DBA_TAB_PRIVS:分配给所有用户的object权限
DBA_COL_PRIVS:分配给用户的对象的列的权限
查看当前用户的角色:user_role_privs
SQL>select * from user_role_privs;
查看序列号,last_number是当前值
SQL>select * from user_sequences;
查看某表的约束条件
SQL>select constraint_name, constraint_type,search_condition, r_constraint_name from user_constraints where table_name = upper('&table_name');
查看视图的名称
SQL>select view_name from user_views;