Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Unexpected result from ALL_TABLES

Re: Unexpected result from ALL_TABLES

From: kinzlaw cgm <kinzlaw_at_gmail.com>
Date: Fri, 10 Aug 2007 16:13:31 +0800
Message-ID: <f4e9b5a90708100113q4896bbe2x82c74619356d7f9f@mail.gmail.com>


Hi, Dennis.
Sorry that I can't answer all your questions as I'm just new to Oracle. Except with this

> 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.

Actually, ALL_TABLES is a data dictionary view(I hope you know data dictionary
anyway) provided by the DBMS, it tells you all the tables' information on the system.
But those tables listed here don't have to be accessable by you, with the priviledges
managed in Oracle with priviledges and roles. What you misconcepted with ALL_TABLES would be USER_TABLES, the latter says all the tables you owned or created(this saying maybe not absolutely correct). I guess you'd better get some book or just the Docs from Oracle for some basic
knowledge about Oracle.

-- 
Learning Oracle
http://kinzlaw.wordpress.com

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Aug 10 2007 - 03:13:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US