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

  • From: drumil narayan <drumilnarayan@xxxxxxxxx>
  • To: askdba@xxxxxxxxxxxxx
  • Date: Tue, 23 Nov 2004 11:48:10 +0000 (GMT)

hello,

i cheked with scott, i tried explicitly, also gave the
sysdba role. 
if tried now select * from v$parameter query returns
the rows..still then problems persists..

now where to check up kindly inform..drumil


 --- "Pepling, Todd C." <tpepling@xxxxxxx> wrote: 
> 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.
> 
>  

________________________________________________________________________
Yahoo! India Matrimony: Find your life partner online
Go to: http://yahoo.shaadi.com/india-matrimony

Other related posts: