triphen
asked on
SyBase SQL Anywhere v10
Hey Experts,
I am running a SQL select statement "select password from dbo.systemlogins" and it returns "(Bytes)". How can I see this in clear text? Is it possible?
I am running a SQL select statement "select password from dbo.systemlogins" and it returns "(Bytes)". How can I see this in clear text? Is it possible?
ASKER
Can I see the hash value?
Sure. Just use CONVERT function to convert it to varchar.
ASKER
how would I write that?
Convert password from dbo.systemlogins (Varchar)?
Convert password from dbo.systemlogins (Varchar)?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I run that query and get the attached result.
Keep in mind I am running this query with a user who ONLY has read access to the DB. Will this make a difference?
Keep in mind I am running this query with a user who ONLY has read access to the DB. Will this make a difference?
So, when you supply your password, the system uses the same one-way hash function to your input and then it compares the result with the information stored in password column. This way it can verify, whether you supplied correct password. But the password itself can't be restored from hash value.