Oracle rechte / priviliges

-- which grants has username on tables ? / welche echte hat username auf tabellen ?
select * from user_tab_privs where grantee like 'username';

--generates grant statements for / erzeugt gran statements ü upd,del,ins,sel
select 'grant SELECT, INSERT, UPDATE, DELETE on "ownername"."' || table_name || '" to "username" ;'  from user_tables where table_name like 'T_%'

System Privilegs / Rechte

 select * from user_sys_privs;
 select * from dba_sys_privs;
 select * from session_privs;

Object privilegs / Rechte

 select * from all_tab_privs;
 select * from user_tab_privs;
 select * from dba_tab_privs;

to all tables:

grant select any table, insert any table, delete any table, update any table to myuser;