Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Viewing DBA_* tables

Re: Viewing DBA_* tables

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Thu, 21 Oct 1999 18:09:33 +0200
Message-ID: <940522195.11278.0.pluto.d4ee154e@news.demon.nl>


That user needs to have either select any table privilege or the DBA = role. As the DBA role is very powerful using it is probably unsuitable.

Hth,

--
Sybrand Bakker, Oracle DBA
  Gregory P Lechkun <lechkung_at_dteenergy.com> wrote in message = news:380F29FB.683E4825_at_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 - 11:09:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US