Re: Unexpected result from ALL_TABLES

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: oracledba.williams@xxxxxxxxx
  • Date: Wed, 8 Aug 2007 15:43:17 -0700

On 8/8/07, Dennis Williams <oracledba.williams@xxxxxxxxx> wrote:
> My question is why a user can see tables in ALL_TABLES that they can't
> select? Is there a better way to do this? I thought about doing this from
> DBA_TABLES, but was concerned about the different permutations of whether a
> table was granted to a role, then granted to the users. I thought if the
> user could see the table in ALL_TABLES, then the user would indeed have
> access, but apparently it isn't that simple.

Hi Dennis,

Could you reproduce this experiment with 2 sessions, showing the output from

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: