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 ...
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:
system privileges
select *
from dba_sys_privs
where grantee = :username
object grants
select *
from dba_tab_privs
where grantee = :username
Permissions grante...
