Could you please help me to find out , a particular user has access to which all tables and has what privilege on those tables .
Make a query on the following tables:
Please also have a look at the privilege related dictionary tables:
SQL> select table_name from dictionary
2 where table_name like '%PRIVS%';
Hope this helps!
Could you please let me know if i can use these tables for getting the required information as sys user .
Eg i want to know the details for a user say " XXABC" , so will i be able to do the same by using these table while logged in via sys user.
Yes, you may query dictionary tables, but please use tables: