Re: Unexpected result from ALL_TABLES

On 8/8/07, Dennis Williams <oracledba.williams_at_gmail.com> 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

--
http://www.freelists.org/webpage/oracle-l