| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.tools -> Re: Sysdba privileges
This is the result of select * from v$pwfile_users statment:
USERNAME
> There shouldn't be any problem in connecting as SYSOPER. The only
difference
> is a SYSDBA has the privilege to create a database.
If I am not sysdba I cannot export or import database, and that is what I
need.
Best regards from Poland
Jacek
U¿ytkownik Sybrand Bakker <postbus_at_sybrandb.demon.nl> w wiadomo¶ci do grup
dyskusyjnych napisa³:910b4m$2i81r$1_at_ID-62141.news.dfncis.de...
> 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 Mon Dec 11 2000 - 03:26:51 CST
 |
 |