Re: ORA-00942

Your test user does not have the DBA privilege to view the data. Show parameter is just a lookup of the v$parameter view.

M

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 - 08:50:59 CST