Grant Select on DBA Views

From: Boobie <boobie.clj_at_mailnull.com>
Date: Tue, 4 Oct 2005 15:46:50 -0400
Message-ID: <dhult6$at7$1@reader1.panix.com>

10gR1 - just a play env.

How can I grant SELECT on these views to non-DBA user ?

DBA_COL_COMMENTS
DBA_CONS_COLUMNS
DBA_CONSTRAINTS
DBA_DEPENDENCIES
DBA_ERRORS DBA_IND_COLUMNS
DBA_INDEXES
DBA_JOBS
DBA_JOBS_RUNNING DBA_OBJECTS
DBA_SEQUENCES
DBA_SOURCE
DBA_SYNONYMS
DBA_TAB_COLUMNS
DBA_TABLES DBA_TRIGGERS
DBA_VIEWS

As DBA-user I get

mighty_dba> grant select on DBA_COL_COMMENTS to notadba ;

grant select on DBA_COL_COMMENTS to notadba ORA-01031: insufficient privileges Received on Tue Oct 04 2005 - 14:46:50 CDT