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
each?
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Other related posts:
