Change the password with SP_PASSWORD
-
Hello, good afternoon,
I'm wondering if anybody has an experience about the following: I have the need of making a process in my system, to let users use an application where they are going to be able to change their password whenever they want, and we want to add this application to all our systems.
My problem is that I'm developing some stored procedures for validating passwords, encripting, changing, etc, and if I want to change the passwords I can do it making an update sentence to the table where I keep passwords, but I can't change the password in the login defined to access the database, I try to use the sp sp_password, but it doesn't work, and of course it doesn't work because it's not possible to run this stored procedure since a user defined stored procedure or function.
So, my question, isn't there a way to run the sp_password since a user defined function or sp or another option in the database? only since my application code?
Thanks a lot,
L.I. Amaury C.R.
-
Okay this can be simple or complex:
Simple
Use windows authentication. Ctrl+Alt+Del > Change password
Authentication protocols, password complexity and encryption is handled for you.
Not so simple
Upgrade to SQL Server 2005, use SQL logins > SP_Password
Authentication protocols, password complexity and encryption is handled for you.
Complex
"developing some stored procedures for validating passwords, encripting, changing, etc..."
-
sp_password can be used to change your own password using the syntax sp_password 'oldpw','newpw'
but if you want to change the password of someone else then the user that you are logged in with must be at least in the server's security administrator group and you would use the extended syntax sp_password null,'newpw',login
and remember, you cannot invoke sp_password from within a transaction
-
Thanks a lot for your comments...
Have a good day,
L.I. Amaury C.R.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply