Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Enabling "Enforce password expiration" on an account with an old password Expand / Collapse
Author
Message
Posted Wednesday, November 6, 2013 8:19 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 10:27 AM
Points: 988, Visits: 5,186
Noetic,

That's what I was afraid would happen. I'll have to talk this over with my boss, see how he wants to tackle it. It was like this when I started, despite the requirement, so maybe someone either was gaming the system (auditor is coming! Enable it!) or they got a "pass" on having it enabled.
Post #1511902
Posted Friday, August 8, 2014 7:16 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Friday, August 8, 2014 7:13 AM
Points: 662, Visits: 464
Well you can alter all the current users by running below code...

USE master

SELECT 'ALTER LOGIN ' + '[' + name + ']'+ ' WITH
CHECK_POLICY = ON,
CHECK_EXPIRATION = ON; 'FROM sys.sql_logins
WHERE is_policy_checked = 0
or is_expiration_checked = 0

Execute your results and you should be fine!
Post #1601160
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse