Re: List grants?

From: Steve Ashmore <sashmore_at_neonramp.com>
Date: Wed, 2 Apr 2003 05:42:16 -0600
Message-ID: <v8lj63h0vvr7d6@corp.supernews.com>

Try looking in dba_tab_privs

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com
Author of: 'So You Want to be an Oracle DBA?'

"Richard B. Kreckel" <richard.kreckel_at_framatome-anp.com> wrote in message news:fdf52b9b.0304020204.d121674_at_posting.google.com...
> Hi,
>
> Here is a beginner's question:
> How do I find out which grants were given/revoked to/from public
> on a given table? I've tried looking at various places like
> dba_sys_privs, but to no avail. The all seemed to be unaffected
> by grants I gave as DBA.
>
> Regards
> -richy.
Received on Wed Apr 02 2003 - 05:42:16 CST