[askdba] Re: Do not have priv on sys.V$Parameter view

  • From: "Pepling, Todd C." <tpepling@xxxxxxx>
  • To: "'askdba@xxxxxxxxxxxxx'" <askdba@xxxxxxxxxxxxx>
  • Date: Mon, 22 Nov 2004 08:21:35 -0500

I'd guess SCOTT has select privs on V$PARAMETER via a role, which isn't good
enough for PLSQL.  SCOTT need explicit SELECT privs on V$PARAMETER.

> -----Original Message-----
> From: drumil narayan [mailto:drumilnarayan@xxxxxxxxx]
> Sent: Monday, November 22, 2004 12:32 AM
> To: askdba@xxxxxxxxxxxxx
> Subject: [askdba] Do not have priv on sys.V$Parameter view
> Hello,
> its related with oracle designer.
> while creating the repository have faced this error.
> platform is 9ir2, windows 2000 box.
> it allows me to log in as scott/tiger when i press the
> said install/create repository it opens up a windows
> there every option has default value as system i
> changed it to users, as user is scott.
> then when i click on start button it gives me the
> errors as you do not have select privileage on
> sys.v$parameter view.
> so i checked with scott..
>  i can very well select rows from v$paramter
> please suggest what should i do...
> ______________________________________________________________
> __________
> Yahoo! India Matrimony: Find your life partner online
> Go to: http://yahoo.shaadi.com/india-matrimony
This email and any files transmitted with it are confidential and intended 
solely for the use of the individual or entity to whom they are addressed. If 
you have received this email in error please notify the system manager. This 
message contains confidential information and is intended only for the 
individual named. If you are not the named addressee you should not 
disseminate, distribute or copy this e-mail.

Other related posts: