Viewing DBA_* tables

From: Gregory P Lechkun <lechkung_at_dteenergy.com>
Date: Thu, 21 Oct 1999 10:58:03 -0400
Message-ID: <380F29FB.683E4825@dteenergy.com>

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 - 09:58:03 CDT