Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Viewing DBA_* tables
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.comDTE // // // //