Re: ORA-00942

Hi,

Thanks. You may be correct.

As i am new to oracle, I don't know how to give the "select rights" on sys.v_$parameter.

Could you please tell me how to do this ? Thanks.

Niall Litchfield wrote:

> 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 - 07:20:56 CST