select * from cat select * from tab select * from user_catalog select * from user_objects select * from user_source -- actual code of procedures select * from user_tables select * from all_tables select * from user_tab_columns select * from user_views select * from user_triggers select * from user_procedures -- list of procedures select * from user_tab_privs -- permissions select * from user_errors -- undisplayed error messages select * from all_errors