Re: ORA-00942

ShravanaKumar wrote:

> 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.
> > >

No seems to have given you the direct answer so here it is:

Log on as SYS and:

SQL> GRANT SELECT ON v_$parameter TO <schema_name>

Then log back on as your develoment schema owner.

Daniel Morgan Received on Mon Feb 17 2003 - 10:48:32 CST