Re: find out on which tables a user has read/write access

From: Steffen Ramlow <s.ramlow_at_gmx.de>
Date: Thu, 7 Mar 2002 10:17:58 +0100
Message-ID: <a67b7b$c8br5$1@ID-54600.news.dfncis.de>

"Jaap W. van Dijk" <j.w.vandijk.removethis_at_hetnet.nl> wrote in message news:3c86a92b.4033423_at_news.freeler.nl...
> DBA_TAB_PRIVS will not tell you directly the privileges you have. You
> can have privileges that have been granted to a role that has been
> granted to a role that has been granted to a role ... that has been
> granted to a role that has been granted to you.

yapp, that is the prob!

>
> To rephrase the question: is there a generic query (that will respond
> reasonably quick) and that gives you the table privileges granted to
> you, either directly or through a role or a chain of roles.

exactly

>
> Oracle itself seems to be able to do this with the system privileges
> with the view SESSION_PRIVS, and the roles granted to you by the view
> SESSION_ROLES. Maybe the text of these views will give you insight in
> how you should go about achieving your goal.

i will look into it Received on Thu Mar 07 2002 - 03:17:58 CST