Alec,
An excerpt from
Oracle Database Reference (chapter on dynamic performance views):
The catalog.sql script contains definitions of the views and public synonyms for the dynamic performance views. You must run catalog.sql to create these views and synonyms. After installation, only username SYS or anyone with SYSDBA role has access to the dynamic performance tables.
I believe the "catalog.sql" script is usually run as part of the installation process -- so you shouldn't need to run it.
In order to grant access, use the "GRANT" (SQL) statement -- but either as the SYS user, or some other user that has the SYSDBA role. See the
Oracle SQL Reference for more details, but it should be something like:
But please verify that with the documentation -- I am only going from memory.
Good Luck,
Avi.
[ April 06, 2005: Message edited by: Avi Abrami ]