Re: ORA-00942

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Mon, 17 Feb 2003 08:49:42 -0800
Message-ID: <3E5112A6.8681725A@exesolutions.com>

Sybrand Bakker wrote:

> 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.
>
> Insufficient privilege. Show parameter selects from the
> datadictionary, which is not visible completely to everyone. You'll
> need to grant your user the select_catalog_role
>
> Hth
>
> Sybrand Bakker
> Senior Oracle DBA

I never thought I'd hear you suggest granting the full role when a single GRANT SELECT ON would do.

Getting easy on developers this year?

Daniel Morgan Received on Mon Feb 17 2003 - 10:49:42 CST