for the query
select user_id, password
the password column is coded - something like in the unix passwd file. I think that java application did that.
- How can I see the origin of the column
- When I want to update this table, with a sql or pl/sql, how to do so
No one can see the unencrypted value for a password, not even the DBA. It's been that way since at least 7.3.2, so I don't think the implementation is Java related.
Anyone with the appropriate privilege may assign a new password to a user by:
alter user bob identified by 'new_password';
If you want, you can have the OS (Unix or NT) authenticate the user by:
alter user bob identified externally;
This prevents the user from having to maintain multiple passwords.
but this is the table from schema that application (subscriber management) using it -users data.
and the data type of the password column is varchar2.
Click Here to Expand Forum to Full Width