Re: Viewing DBA_* tables

To answer TurkBear's question, I get the same error when using sys.dba_views.

I guess what I'm hearing is that...

> I'm just starting off as my departments DBA, and I created an account
> on our development database (Oracle V7.3.2.3, VMS V7.1). I connected
> to the account I created and everything appears fine, except when I
> try to select tables like "dba_views", and I get an "ORA-00942: table
> or view does not exist".
>
> I check and found that the public synonym does exist. What's the
> problem? ...

I need to grant select priv. to the tables if I want the account to query the tables (even though the synonym exist).

> Do I have to grant select on the dba_* tables to the newly created
> account? I thought in V7.3.2.3 the DBMS allows access to those tables
> by default, and that access isn't restricted, and that restrictions to
> the dba_* tables occur in V8.0 and up.

Even though the synonyms exist, it does mean the tables can be queried.

--
Regards,
Greg Lechkun
gpl :-)

DTE

Energy====================================================================

DTE     ////// ////////////       Gregory Lechkun - EM&D/PDO-PT
DTE    //   //  //   //           Power Application Software Engineer
DTE   //   //  //   ////          lechkung_at_detroitedison.com