Re: Viewing DBA_* tables

Can you do a select on sys.dba_views ?
If so, then the synonym may be somehow messed up..try creating a new one...

If not, then you will probably need to grant the permission...

Gregory P Lechkun <lechkung_at_dteenergy.com> 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 ////// // //////
>

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Thu Oct 21 1999 - 11:06:26 CDT