Query DBA_TAB_PRIVS . Remember that the GRANTEE could also be a ROLE so you'd have to also query DBA_ROLE_PRIVS to see who has been granted the ROLE. Hemant --- Dean Paul <oracledbam@xxxxxxxxxxx> wrote: > Hi, > > I want to see which views has been granted to whome? > Which table has all object privileges? > Thx > > Hemant K Chitale http://web.singnet.com.sg/~hkchital -- //www.freelists.org/webpage/oracle-l