This discussion is archived
1 Reply Latest reply: Oct 10, 2012 12:00 AM by GauravBhide RSS

SQL Plus not work with domain user

967113 Newbie
Currently Being Moderated
Hey guys,

have a problem with sql plus in our network. when i started it with the admin it works. but when i started it with a user account, fill in the username, the password and the host and click on the ok button, the window closes and nothing happen. no error no new window, the window simply closes.

what to do?


regards
  • 1. Re: SQL Plus not work with domain user
    GauravBhide Newbie
    Currently Being Moderated
    Hi,

    There might be different reasons behind this.

    Check whether user is created in database or not.

    There might be possibility that, user is in different database.
     
    
    SELECT * FROM V$DATABASE; --This will help you to findout database name. 
    
    SELECT * FROM DBA_USERS WHERE USERNAME = 'HR';  --HR is user present on database. 
    If your user is present in database then user might not have connect privilege.
     
    
    GRANT CONNECT , RESOURCE TO HR; --HR is user. To execute this command, login as sys 
    You can also try to login with command prompt.
     
    
    sqlplus user/password@host 

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points