Re: Sysdba privileges

An incorrect answer provided to you...

Which accounts have sysdba (and sysoper privilege) depends on the value of the parameter remote_login_password_file. none means only internal has sysdba
shared means internal and sys have sysdba exclusive means any user can get sysdba provided it is granted to him. You can verify which users are enabled for SYSDBA in your current installation by connect as normal
and issue select * from v$pwfile_users (in Personal Oracle 8.1.5 this seems to result in ora-600, but normally it works). There shouldn't be any problem in connecting as SYSOPER. The only difference is a SYSDBA has the privilege to create a database.

Regards,

Sybrand Bakker, Oracle DBA

"Chmielewski Jacek" <jacekch_at_mail.atr.bydgoszcz.pl> wrote in message news:910172$6m5$1_at_flis.man.torun.pl...
> OK, I have started Oracle DBO studio in stand alone mode - user
 SYS/password
> change_on_install, Connect as: sysdba - error ORA-01031 insufficient
> privileges !!! I can login as SYSOPER but SYSDBA is not accesible !!!
> What is up ?
>
> Jacek
>
>
> U¿ytkownik Thomas Devallé <thomas.devalle_at_skynet.be> w wiadomo¶ci do grup
> dyskusyjnych napisa³:90vq9f$sv8$1_at_news0.skynet.be...
> > 1. SYSTEM (password Manager) and SYS (password change_on_install).
> > 2. I never used it SQAL Server..
> > 3. There's an expert with Oracle tools to do it.
> >
> > "Chmielewski Jacek" <jacekch_at_mail.atr.bydgoszcz.pl> wrote in message
> > news:90tvr2$go6$1_at_flis.man.torun.pl...
> > > I am a new Oracle user and I have some surely simpy questions.
> > > 1. What is default user with sysdba privilege ?
> > > 2. In Oracle Enterpise Manager I can see my SQLServer runing, but I
 cannot
> > > do anything with it ? How can I get an access to it.
> > > 3. How can I export/imprt data ?
> > >
> > > Best regards
> > > Jacek
> > >
> > >
> >
> >
>
>
Received on Sun Dec 10 2000 - 09:12:41 CST