Re: view ROLES

From: Steve Blomeley <steveblomeley_at_yahooDOTco.uk>
Date: Mon, 19 Mar 2001 01:43:59 +0000
Message-ID: <3AB5645F.B522D55B@yahooDOTco.uk>

"Chirag (Mark) Patel" wrote:
>
> I would like to view the ROLES that have been granted to me for specific
> tables. So, how can I find out if I can INSERT/DELETE/UPDATE to a specific
> table in the database?
>
> Thanks.

To list the object privileges that have been granted directly to you, query the USER_TAB_PRIVS view.

To list the object privileges granted to you via roles, query ROLE_TAB_PRIVS. HTH
SB Received on Sun Mar 18 2001 - 19:43:59 CST