Re: PRIVILEGES

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_at_hotmail.com> 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

--
http://www.freelists.org/webpage/oracle-l