Re: PRIVILEGES

  • From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
  • To: oracledbam@xxxxxxxxxxx, Dean Paul <oracledbam@xxxxxxxxxxx>
  • Date: Fri, 15 Sep 2006 15:23:27 +0800 (SGT)

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


Other related posts: