Re: ORA-00942

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 17 Feb 2003 06:57:53 -0800
Message-ID: <a20d28ee.0302170657.7bdb104d@posting.google.com>

ShravanaKumar <shravanakumar.ks_at_siemens.com> wrote in message news:<3E50C9A6.BC443B76_at_siemens.com>...
> Hi All,
>
> We are using oracle 9.2.0 on solaris 8.
>
> I created a user called "test" in my "test" database. I get the
> following error,
> when i execute the following at SQL> prompt.
>
> SQL> show parameter
> ORA_00942: table or view does not exist.
>
> But, the same will work, if connect as a sysdba.
>
> Can some one tell what is the problem with my user ?
>
> Thanks a lot,
>
> Best Regards,
> ShravanaKumar.

Insufficient privilege. Show parameter selects from the datadictionary, which is not visible completely to everyone. You'll need to grant your user the select_catalog_role

Hth

Sybrand Bakker
Senior Oracle DBA Received on Mon Feb 17 2003 - 08:57:53 CST