To check the user Privilages and Roles........

select  privilege||' '||table_name  "Privileges for N514012" from  dba_tab_privs where  grantee='&data'
union
select  privilege from  dba_sys_privs where grantee='&data'
union
select granted_role from dba_role_privs where  grantee='&data';


select 'grant select on  '||owner||'.'||object_name||' to xxint;' from dba_objects where owner='XXDW' and object_type='TABLE';