ORA-00942

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Mon, 17 Feb 2003 17:25:10 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA70350AA29@lnewton.leeds.lfs.co.uk>

Morning/afternoon/evening Gents,

SELECT_CATALOG_ROLE doesn't give select access to V$Parameters - at least not on my HP 9iR2 system it doesn't :

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production With the Partitioning option
JServer Release 8.1.7.4.0 - 64bit Production

SQL> connect cmdb_at_cmdb
Enter password: **********
Connected.
SQL> show parameter buffer
ORA-00942: table or view does not exist

SQL> connect system_at_cmdb
Enter password: **********
Connected.
SQL> grant SELECT_CATALOG_ROLE to cmdb;
Grant succeeded.

SQL> connect cmdb_at_cmdb
Enter password: **********
Connected.
SQL> show parameter buffer
ORA-00942: table or view does not exist

SQL> connect system_at_cmdb
Enter password: **********
Connected.
SQL> revoke SELECT_CATALOG_ROLE from cmdb; Revoke succeeded.

SQL> connect sys_at_cmdb
Enter password: **********
Connected.
SQL> grant select on V_$Parameter to cmdb; Grant succeeded.

SQL> connect cmdb_at_cmdb
Enter password: **********
Connected.
SQL> show parameter buffer;

NAME                                 TYPE        VALUE
------------------------------------ -----------
------------------------------
buffer_pool_keep                     string      buffers:50,
lru_latches:1
buffer_pool_recycle                  string
db_block_buffers                     integer     2000
log_buffer                           integer     1048576
use_indirect_data_buffers            boolean     FALSE


-------------------------------------

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------

-----Original Message-----
From: DA Morgan [mailto:damorgan_at_exesolutions.com] Posted At: Monday, February 17, 2003 4:50 PM Posted To: server
Conversation: ORA-00942
Subject: Re: ORA-00942

>> I never thought I'd hear you suggest granting the full role when a
single GRANT SELECT ON would do.

>> Getting easy on developers this year?

>> Daniel Morgan
Received on Mon Feb 17 2003 - 11:25:10 CST