From: oratune@aol.com
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server
Subject: Re: NEWBIE: SQL intro
Date: Mon, 16 Oct 2000 20:07:01 GMT
Organization: Deja.com - Before you buy.
Lines: 58
Message-ID: <8sfn50$1fq$1@nnrp1.deja.com>
References: <8sf862$jfu$1@nnrp1.deja.com> <8sf913$k5r$1@nnrp1.deja.com> <8sf9no$kp4$1@nnrp1.deja.com> <971716147.2621.1.pluto.d4ee154e@news.demon.nl>
NNTP-Posting-Host: 38.193.42.5
X-Article-Creation-Date: Mon Oct 16 20:07:01 2000 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
X-Http-Proxy: 1.1 x60.deja.com:80 (Squid/1.1.22) for client 38.193.42.5
X-MyDeja-Info: XMYDJUIDddf_dba


In article <971716147.2621.1.pluto.d4ee154e@news.demon.nl>,
  "Sybrand Bakker" <postbus@sybrandb.demon.nl> wrote:
>
> "Paul Bennett" <spacey845@my-deja.com> wrote in message
> news:8sf9no$kp4$1@nnrp1.deja.com...
> > In article <8sf913$k5r$1@nnrp1.deja.com>,
> >   oratune@aol.com wrote:
> > > In article <8sf862$jfu$1@nnrp1.deja.com>,
> > >   Paul Bennett <spacey845@my-deja.com> wrote:
> > > > Very stupid newbie question about SQL.
> > > >
> > >
> > > Try this:
> > >
> > > select owner, table_name, tablespace_name
> > > from all_tables;
> > >
> >
> > Thanks!  It's bloody obvious once I see it in print in front of me!
> >
> >
> >
> > ---
> > Pb
> > My opinions are my own and should not be taken as
> > representing any other group or entity.
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
> Actually you should know there are three levels:
> user_tables |indexes : your own tables etc.
> all_tables|indexes: all the tables you have access to.
> dba_tables|indexes: all tables in the database.
>
> This could mean the answer from mr. oratune is only partially correct.
>
> Regards,
>
> Sybrand Bakker, Oracle DBA
>
>

It is true that there are three levels of results one could return; two
are accessable by all users, whereas the third, dba_tables, is only
accessable to those granted DBA access.  Should Mr. Bennett not be
granted the DBA role it would be impossible for him to access the DBA_
views.  I attempted to base my response upon general access outside of
the DBA realm.  If that makes my answer incorrect, so be it.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.