Running this script on the main passageways Database (Production_Portal_PortalFX/Passageways) will reset all users in the employee role so that the next time they login to the portal (Forms Authentication) they will be forced to change their password.
update PWUser
set passwordresetflag='1'
WHERE (UserID IN
(SELECT UserID
FROM PWRoleMembers
WHERE (RoleID = 'Employee')))
In SQL you can navigate to SQL Server Agent, Right Click Jobs, New Job.
General - Give Job a name and description
Steps - Step Name, select database to run script on and paste the above SQL script into command box.
Schedules - Schedule Name, Schedule type: Recurring, Occurs Monthly, Day xx of every 3 months, select an after hours time (5:00 AM?), Select Start date with No End Date.
Alerts - Can set this up if you wish it isn't necessary
Notifications - Can set this up if you wish it isn't necessary
Targets - n/a
Comments
0 comments
Please sign in to leave a comment.