I am using TOAD 9.0.1 and Oracle 10.2.0 . As a READ ONLY user , I can connect to database thru SQLPLUS. However while trying to connect thru TOAD, it throws the error " Invalid Username/Password" . I tried all other READ ONLY users, all threw the same error. When trying with READ- WRITE access user, login thru TOAD, it was successful.
Do I need to change any settings in TOAD so that READ ONLY user can login ?
This forum is for problems connecting to non-Oracle databases using Oracle gateways.
As you are trying to connect to an Oracle database then it would be better to ask your question in the RDBMS General forum -
However, as the connection works using SQLPLUS and TOAD is a third party product then they may not be able to give you an answer.