|
TimS
Posting Yak Master
USA
198 Posts |
 Posted - 07/22/2005 : 19:06:57
|
SET QUOTED_IDENTIFIER ON; SET ANSI_NULLS ON
GO
IF OBJECT_ID('dbo.usp_audit_passwords') IS NULL
EXEC ('CREATE PROC dbo.usp_audit_passwords
AS RAISERROR ( ''Dummy Proc Called'', 16, 62)')
GO
ALTER PROC dbo.usp_audit_passwords AS
BEGIN
SET NOCOUNT ON;
IF OBJECT_ID('tempdb..#password') IS NULL
BEGIN
CREATE TABLE #password(
password nvarchar(128) NOT NULL PRIMARY KEY
);
END;
INSERT INTO #password (password)
SELECT src.password
FROM
(
SELECT 'password' UNION ALL
SELECT 'none'
) AS src (password)
LEFT JOIN #password dest ON src.password = dest.password
WHERE dest.password IS NULL
INSERT INTO #password (password)
SELECT DISTINCT l.name
FROM master.dbo.sysxlogins l
WHERE l.name IS NOT NULL AND NOT ((l.xstatus&4) = 4) -- NOT isntname
SELECT l.name, p.password
FROM master.dbo.sysxlogins l
JOIN #password p ON 1 = PWDCOMPARE(p.password, l.password, (CASE WHEN l.xstatus&2048=2048 THEN 1 ELSE 0 END))
END
/***
IF OBJECT_ID('tempdb..#password') IS NOT NULL DROP TABLE #password
CREATE TABLE #password(
password nvarchar(128) NOT NULL PRIMARY KEY
);
INSERT INTO #password (password) VALUES ('checkthispassword')
EXEC dbo.usp_audit_passwords
***/
GO
|
|
usp_audit_passwords
