Re: NEWBIE: SQL intro

In article <971716147.2621.1.pluto.d4ee154e_at_news.demon.nl>,   "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
>
> "Paul Bennett" <spacey845_at_my-deja.com> wrote in message
> news:8sf9no$kp4$1_at_nnrp1.deja.com...
> > In article <8sf913$k5r$1_at_nnrp1.deja.com>,
> > oratune_at_aol.com wrote:
> > > In article <8sf862$jfu$1_at_nnrp1.deja.com>,
> > > Paul Bennett <spacey845_at_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.