User_tab_Privs

[giddy]

All,

How do I find out whether a User has access to a particular Table, I have tried using User_tab_privs, but it doesn't give me the info I need, can anyone help ?

[pando]

you which table you have access or which user has access to your tables?

[giddy]

whether a user has access to particular table or not

[pando]

select * from dba_tab_privs where table_name='XXX' and owner='YYY'

[jmodic]

User can have access on a particular table if one of the following three conditions is met:

1. Access to this particular table has been granted to user
2. Access to this particular table has been granted to PUBLIC
3. Acess to *ANY* table has been granted to this user.

select owner, table_name, privilege from user_tab_privs
where (grantee = user or grantee = 'PUBLIC')
and owner = xowner and table_name = xtable
union all
select 'ANY SCHEMA', 'ANY TABLE', privilege from user_sys_privs
where privilege like '% ANY TABLE';

Point 1. and 3. above can also been granted to a role and then this role to a user. So you should enhance the above query by searching if any role granted to user has been granted points 1. and 3.