Re: Viewing DBA_* tables

> Hanway wrote:
>I assume both $ORACLE_HOME/rdbms/admin/catalog.sql and catdbsyn.sql
were
>both run?
>
> David wrote:
>in essence you already have the answer, you need to either grant the
DBA
>role to the new account or, and this is safer, grant select access on
all
>the dba_* objects to the new account logged on as system.
>
>In no releases did automatic access to the dba_* views occur with new
>accounts, many sites however grant access to these tables to a role
commonly
>assigned to developers. eg Create a role of 'Developer_User' grant
select on
>the views to this and assign this role to anyone who might need to look
at
>the dba views. Alternatively you could grant access to an default role
like
>connect or resource.

Yes, catalog.sql was executed (I'm not sure if catdbsyn.sql was).

I suppose that's the source of my confusion, because catalog.sql creates public synonyms for those tables; however, it's up to the DBA to grant select on those tables or in our case, grant select any table privileges (I know, that's not a good privilege to hand out but, they're developers....).

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 - 13:27:14 CDT