oracle user creation and other tables to check roles.

 

   create user <USERNAME> identified by  <PASSWORD>  default tablespace USERS temporary tablespace TEMP profile DEFAULT;

grant CONNECT to <USERNAME>;

grant PSOFT_RO to <USERNAME>;

grant CREATE SESSION to <USERNAME>;

create user <USERNAME> identified by <PASSWORD>;

grant connect , resource, psoft to <USERNAME>;

Misc tables

---------------

select * from dba_role_privs where granted_role ='PSOFT_RO' 

select * from dba_tab_privs where grantee in ('PSOFT_RO','PSOFT_RW');

select * from dba_tab_privs where table_name like '%<TABLE_NAME>';

select * from DBA_SYS_PRIVS  where PRIVILEGE like '%SELECT ANY DICTIONARY%'

select * from dba_role_privs where grantee ='<USERNAME>'