Re: ORA-00942

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Mon, 17 Feb 2003 12:37:03 -0000
Message-ID: <3e50d773$0$811$ed9e5944@reading.news.pipex.net>

you user doesn't have select rights on sys.v_$parameter

--
Niall Litchfield
Oracle DBA
Audit Commission UK

"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 - 06:37:03 CST