User/password incorrect, logon denied

[Guest_imported]

Does anyone know which file to check that the username and password is setup correctly? With my Oracle database, I can logon under username system and password manager, but with another username/password, I can't login. Is the file users.sql? Thanks

 

[jee]

The view DBA_USERS lists user names and passwords, but if your passwords are encrypted, you will only see the encrypted version.

 

[Guest_imported]

Is that view selected from SQL*Plus? Therefore, login under system and then select * from DBA_Users;? Thanks jee

 

[Guest_imported]

User-IDs are stored in an Oracle table.
To see them, run this sqlplus query:

SELECT username FROM dba_users;

Once you have identified the user's name, you can change
its password (to something you'll know) via ALTER USER:

ALTER USER username IDENTIFIED BY newpassword;

If the user does not already exist,
see the CREATE USER command.