connect

[dorothy]

I have 2 users in my DB.
User A has user has DBA role
while User B has connect, resource role.

If I use user A's account/password, I'm able to connect
to the sever from my client.

If I use user B's account/password, I'm not able to connect
to the sever from my client.

The listerner is up and the TNSNAMES seem to be fine.

[sln81]

Are you able to connect as User B on the server itself?

[dorothy]

Both users have no user_id on the box itself.

[marist89]

What error message are you getting?

[dorothy]

This is the error message that I get:

invalid username/password

but the username and passwords are connect directly to the database when I telnet to the server.

[tycho]

Hi

Can you alter the password for user B and try again?

(Just for a test to be sure)

Hope t hear from you.

Tycho

[sambavan]

Do


alter user user_name identified by password;

Then try again. It looks like the problem in the login password.

Sam