Check out Richards advice re permissions and the Oracle concepts manual. The
manuals are all available at http://tahiti.oracle.com (requires a free
registration to technet which is A Good Thing (tm)).
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"ShravanaKumar" <shravanakumar.ks_at_siemens.com> wrote in message
news:3E50E1B8.344109A_at_siemens.com...
> 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 - 08:01:28 CST
