Connect to sqlplus as sysdba

[Poki]

Hello,
Can somebody please tell me where can i configure that the user that connects to sqlplus doesn't need to provide password,
for eg. : sqlplus "/as sysdba" and you are connected, you are not prompted with password

If i want some user to be able to connect just like that , where do i set it?

Or is it just sys priviliges?

Thank you

[davey23uk]

as in all the manuals and all over the internet

the user mut be in th relevant os group

[Poki]

as in all the manuals and all over the internet

the user mut be in th relevant os group

Hi ,
I did all these steps:
1. Create the Windows user:

start --> settings --> control panel --> administrative tools --> computer management --> user

2. Add the new user to the Oracle group:

start --> settings --> control panel --> administrative tools --> computer management --> groups

3. Add user to OS Database Administrator:

start --> programs --> oracle home --> configuration and migration tools --> administration for windows NT --> OS database administrator

4. Add user to OS Database Operators:

start --> programs --> oracle home --> configuration and migration tools --> administration for windows NT --> OS database operators

5. Add user to OS Administrator:

start --> programs --> oracle home --> configuration and migration tools --> administration for windows NT --> OS administrator

6. Add user to OS Operators:

start --> programs --> oracle home --> configuration and migration tools --> administration for windows NT --> OS operators

7. Add os_authent_prefix=OPS$ to your initialization parameters (pfile or spfile) and bounce Oracle database, if necessary.

and i bounced the db

and i still can't connect to sqlplus without password


so i am trying sqlplus "/as userthaticreated"

[davey23uk]

nne of that is correct, you need to add them into the ORA_DBA group

[Poki]

nne of that is correct, you need to add them into the ORA_DBA group

I added to user to the dba_ora group

[davey23uk]

I added to user to the dba_ora group

well try adding them to the ORA_DBA group instead