Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle 9i - sys login question

Re: Oracle 9i - sys login question

From: Marco Casale <mjcasale_at_yahoo.com>
Date: 22 Dec 2001 20:14:01 -0800
Message-ID: <f79df195.0112222014.40a0722d@posting.google.com>


Ron Reidy <rereidy_at_indra.com> wrote in message news:<3C24F156.BFC2380F_at_indra.com>...
> Marco Casale wrote:
> >
> > Hi,
> >
> > I'm trying to setup an application called Spotlight made by Quest
> > software to monitor my Oracle database. I need to login as SYS in
> > order to setup the 'spotlight' user account in Oracle. Unfortunately,
> > I can't login as SYS. Is there a way to change the sys account so
> > that I can login a SYS normal? I'm only able to login as SYS as
> > SYSDBA.
> >
> > I'm running Oracle 9i on both Win2k and Solaris 8. When I try logging
> > in as a different DBA account , Spotlight tells me insufficient
> > privileges but doesn't explain anything further.
> >
> > Any advice is appreciated.
> >
> > Thank you,
> >
> > Marco
> Look here...
> http://asktom.oracle.com/pls/ask/f?p=4950:8:350839::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:940042518290,%7Bsysdba%7D

Thank you both Ron and Pete,

I tried out the 07_dictionary_accessibility=true and it worked. I was able to login as sys as NORMAL. I was then able to install the application Spotlight on Orace by Quest. The Oracle article that you pointed me to was informative.

Thank you,

Received on Sat Dec 22 2001 - 22:14:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US