Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
Parameters
3| Name | Data Type | Length | Description |
|---|---|---|---|
| @username | varchar | 60 | |
| @userID | int | 4 | |
| @NewPassword | varchar | 100 |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE OR ALTER PROCEDURE dbo.user_login_purge
@username varchar(60),
@userID int,
@NewPassword varchar(100)
AS
BEGIN
SET NOCOUNT ON;
/*
select * from users where username='cencosud'
select * from usuarios_productos where user_id=930918655
select * from users_enc_pwd where user_id=930918655
*/
-- Ponemos contraseña provisoria
update users set password='123456' where user_id=@userID
-- borramos el historial de contraseñas para poder usar alguna ya usada
delete users_enc_pwd where user_id=@userID
-- generamos la nueva contraseña encriptada
exec user_login @username,'123456',1000,10,20,0,'CHANGEPWD',@NewPassword
--exec user_login @username,@NewPassword,10,10,20,0,'LOGIN',NULL
-- estiramos las vigencias del usuario para no tener que cambiarlas
-- update users set login_expiration=getdate()+1000 where user_id=@userID
-- update users_enc_pwd set expiration_date=getdate()+1000 where user_id=@userID
END
GO
GO
CREATE OR ALTER PROCEDURE dbo.user_login_purge
@username varchar(60),
@userID int,
@NewPassword varchar(100)
AS
BEGIN
SET NOCOUNT ON;
/*
select * from users where username='cencosud'
select * from usuarios_productos where user_id=930918655
select * from users_enc_pwd where user_id=930918655
*/
-- Ponemos contraseña provisoria
update users set password='123456' where user_id=@userID
-- borramos el historial de contraseñas para poder usar alguna ya usada
delete users_enc_pwd where user_id=@userID
-- generamos la nueva contraseña encriptada
exec user_login @username,'123456',1000,10,20,0,'CHANGEPWD',@NewPassword
--exec user_login @username,@NewPassword,10,10,20,0,'LOGIN',NULL
-- estiramos las vigencias del usuario para no tener que cambiarlas
-- update users set login_expiration=getdate()+1000 where user_id=@userID
-- update users_enc_pwd set expiration_date=getdate()+1000 where user_id=@userID
END
GO
Depends On
3Used By
No items found