[askdba] Re: Do not have priv on sys.V$Parameter view
- From: "Pepling, Todd C." <tpepling@xxxxxxx>
- To: "'askdba@xxxxxxxxxxxxx'" <askdba@xxxxxxxxxxxxx>
- Date: Tue, 23 Nov 2004 07:27:28 -0500
Is it possible the installer logs on like so:
sqlplus "scott/tiger@orcl"
instead of
sqlplus "scott/tiger@orcl as sysdba"
? To be safe, I'd assume SCOTT isn't logging on as sysdba.
I'd try granting explicit select to SCOTT (grant select on sys.v_$parameter
to scott;) and try reinstalling. You might also want to check SCOTT's
default role(s), or perhaps make all SCOTT's roles default (alter user scott
default role all;).
Let us know how it goes.
> -----Original Message-----
> From: drumil narayan [mailto:drumilnarayan@xxxxxxxxx]
> Sent: Tuesday, November 23, 2004 6:48 AM
> To: askdba@xxxxxxxxxxxxx
> Subject: [askdba] Re: Do not have priv on sys.V$Parameter view
>
>
> 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
>
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:
