Re: Viewing DBA_* tables

I assume both $ORACLE_HOME/rdbms/admin/catalog.sql and catdbsyn.sql were both run?

Gregory P Lechkun wrote:

> Hi,
>
> 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? 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.
>
> Thanks in advance,
> Greg Lechkun
> gpl :-)
>
> DTE
> Energy====================================================================
>
> DTE ////// //////////// Gregory Lechkun - EM&D/PDO-PT
> DTE // // // // Power Application Software Engineer
> DTE // // // //// lechkung_at_detroitedison.com
> DTE // // // //
> DTE ////// // //////
>
>
Received on Thu Oct 21 1999 - 12:59:07 CDT