-
Connect to sqlplus as sysdba
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
-
as in all the manuals and all over the internet
the user mut be in th relevant os group
-
Originally Posted by davey23uk
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"
-
nne of that is correct, you need to add them into the ORA_DBA group
-
Originally Posted by davey23uk
nne of that is correct, you need to add them into the ORA_DBA group
I added to user to the dba_ora group
-
Originally Posted by Poki
I added to user to the dba_ora group
well try adding them to the ORA_DBA group instead
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|