How to see password

Question

How to see password

Krasavita

SSC-Insane

Points: 23138
More actions
December 9, 2009 at 9:43 am

#228411

I created a user and password and user doesn't rememeber password,how can I find out his password?

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 1

Change it. You can't decrypt the password for the login unless you have a lot of time to wait for some kind of brute force tool to crack it in a year or two depending on how many characters it was.

Bru Medishetty SSC-Insane Points: 23606 More actions · Answer 2

Krasavita (12/9/2009)
I created a user and password and user doesn't rememeber password,how can I find out his password?

As Jonathan has mentioned, change the pwd and let the user know it.

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.comLearnSQLWithBru

Twitter -- BruMedishetty

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

Better yet, have the user start using Windows Authentication instead of SQL Auth. Then the user will be using windows credentials. If the user can't remember the password to login to the network, then no need to worry about them logging into the database.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Jeff Moden SSC Guru Points: 1004376 More actions · Answer 4

As a side bar... make it company policy that there's a $5 charge for this just as if they'd lost their badge. One of two things will happen after that... it will happen much less frequently or... you'll be able to retire early. 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Krasavita SSC-Insane Points: 23138 More actions · Answer 5

Krasavita

SSC-Insane

Points: 23138

December 10, 2009 at 8:22 am

#1090595

Thank you

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 6

Jeff Moden (12/9/2009)
As a side bar... make it company policy that there's a $5 charge for this just as if they'd lost their badge. One of two things will happen after that... it will happen much less frequently or... you'll be able to retire early. 😉

When I move to my next job, I am implementing this policy. LOL.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 7

You are welcome

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events