Discover user password through Select or View?

Asked

Viewed 5,179 times

-1

I’m running a BD which was made by a developer who created a table of operators, it turns out that he is no longer in the world of the living.

How to discover a user’s password through a table or a View using SELECT * FROM?

sql view
  • 2

    It depends on the table structure and some possible use of encryption. If he used a hash to hide the password, and that hash is 1-way, the most you redeem is the password hash. It may also change if salts and seasonings are used

  • 4

    Password is open or encrypted?

  • Useful reading: https://answall.com/a/2405/64969

  • You can accept the answer by clicking on the left side of it.

1 answer

2

If the passwords are encrypted then it will be very difficult to be able to read them, one way of resolution in this case would be to have access to the project or code, where the encryption of passwords is generated.

On the other hand if you don’t have any kind of encryption passwords, one select to return everything you need, you can use the examples below to query your BD and the desired fields.

To view all fields and records from a table in the DB:

SELECT * FROM nome_tabela;

To view all records of a given table field:

SELECT nome_campo FROM nome_tabela;

If you want a particular user’s pass you can do so:

SELECT * FROM nome_tabela WHERE nome='ze';

Or

SELECT pass FROM nome_tabela WHERE nome='ana';

Anything where I can help, please let us know, you can consult more information here MYSQL or here W3schools, about using SELECT in consultations with the BD.

  • As perceived by Bigown in comment from him if the password undergoes encryption, then the maximum that is redeemed is the encrypted value.

  • 2

    @Jeffersonquesado Yes is right however was not mentioned in the question, case suffers can edit the answer

  • If encrypted, the value is more likely to be non-recoverable. As the question leaves many aspects open, I think it is relevant to raise these possibilities

  • @Jeffersonquesado unless I have access to the project or code through which passes and the pass is generated..

Browser other questions tagged sql view

You are not signed in. Login or sign up in order to post.