DBA_SYS_PRIVS: Assigned to all users SYSTEM permissions SESSION_PRIVS: Permissions for all users DBA_TAB_PRIVS: Allocated to all users Object Permissions DBA_COL_PRIVS: Permissions for columns assigned to the user
View the current user's role: user_role_privs sql> select * from user_role_privs;
View serial number, last_number is the current value sql> select * from user_sequence;
View the constraints of a table SQL> select constraint_name, constraint_type, search_condition, r_constraint_name from user_constraints where table_name = Upper ('& Table_name');
View view of the name SQL> Select View_name from user_views;
