Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-00942
You need SELECT ON V_$PARAMETER object privileges to use the
PARAMETERS clause, otherwise you will receive a message
ORA-00942: table or view does not exist
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.
Received on Mon Feb 17 2003 - 10:50:58 CST