Re: view ROLES

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Sun, 18 Mar 2001 12:18:43 GMT
Message-ID: <3ab4a694.22897329@news-server>

On Sun, 18 Mar 2001 05:04:45 -0500, "Chirag (Mark) Patel" <patelc_at_mcss.cas.mcmaster.ca> 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?

Do a describe of USER_TAB_PRIVS and take it from there. There is also DBA_TAB_PRIVS. Don't pin me down to the exact name, you can always look it up in USER_VIEWS.

Cheers
Nuno Souto
nsouto_at_bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Sun Mar 18 2001 - 06:18:43 CST