?
Solved

SyBase SQL Anywhere v10

Posted on 2011-04-26
6
Medium Priority
?
319 Views
Last Modified: 2012-05-11
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?
0
Comment
Question by:triphen
  • 3
  • 3
6 Comments
 
LVL 14

Expert Comment

by:Jan Franek
ID: 35475721
As far as I know (and I hope), is is not possible to "decrypt" password. It should be stored using one-way hash algorithm.

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.
0
 

Author Comment

by:triphen
ID: 35476567
Can I see the hash value?
0
 
LVL 14

Expert Comment

by:Jan Franek
ID: 35482638
Sure. Just use CONVERT function to convert it to varchar.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Author Comment

by:triphen
ID: 35485388
how would I write that?

Convert password from dbo.systemlogins (Varchar)?

0
 
LVL 14

Accepted Solution

by:
Jan Franek earned 2000 total points
ID: 35489692
select convert( varchar(100), password) from dbo.systemlogins
0
 

Author Comment

by:triphen
ID: 35489703
I run that query and get the attached result.
 ResultsKeep in mind I am running this query with a user who ONLY has read access to the DB. Will this make a difference?
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question