About Tables and Privileges

[ramuganapathi]

Hi,

How to find what are the privileges available for the user in a particular table.

or in otherwords, what are the privs available for the user in a particular table provided the userid and tablename.

Please let me know the query, or which dictionary table I need to look into.....

Oracle Database version: 8i

Thanks in advance

Regards
Ramu Ganapathi

[rotem_fo]

select GRANTOR, PRIVILEGE, TABLE_NAME
from DBA_TAB_PRIVS
where GRANTEE='USERNAME'
and TABLE_NAME='TABLE_NAME'
/

cheers.