select * 
from dba_objects

USER_SOURCE describes the text source of the stored objects owned by the current user. This view does not display the OWNER column.

select * from user_source where type='TRIGGER' and lower(text) like '%order%' 

ALL_SOURCE describes the text source of the stored objects accessible to the current user.

select * from all_source where owner=:owner

DBA_SOURCE describes the text source of all stored objects in the database.

select * from dba_source

select owner, table_name
from all_tables

ALL_TAB_COLUMNS describes the columns of the tables, views, and clusters accessible to the current user. COLS is a synonym for USER_TAB_COLUMNS.

select *
from all_tab_columns
where table_name = :tname

All roles granted to user.

select * 
from dba_role_privs 
where grantee= :username

Privileges granted to user:

1. system privileges

select * 
from dba_sys_privs 
where grantee = :username

2. object grants

select * 
from dba_tab_privs 
where grantee = :username

Permissions granted to roles.

Roles granted to other roles.

select * 
from role_role_privs 
where role in (select granted_role from dba_role_privs where grantee= :username)

1. system privileges

select * 
from role_sys_privs  
where role in (select granted_role from dba_role_privs where grantee= :username)

2. object grants

select * 
from role_tab_privs  
where role in (select granted_role from dba_role_privs where grantee= :username)

select * 
from v$version

select * from dict