Connect to sqlplus as sysdba
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Connect to sqlplus as sysdba

Hybrid View

  1. #1
    Join Date
    Jul 2009
    Posts
    3

    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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    as in all the manuals and all over the internet

    the user mut be in th relevant os group

  3. #3
    Join Date
    Jul 2009
    Posts
    3
    Quote Originally Posted by davey23uk View Post
    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"

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    nne of that is correct, you need to add them into the ORA_DBA group

  5. #5
    Join Date
    Jul 2009
    Posts
    3
    Quote Originally Posted by davey23uk View Post
    nne of that is correct, you need to add them into the ORA_DBA group
    I added to user to the dba_ora group

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    Quote Originally Posted by Poki View Post
    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
  •  



Click Here to Expand Forum to Full Width