SQL Server Performance Forum – Threads Archive
Disabling User Login
I need to disable a user’s login after 90 days. The userid and password are stored in a user table. Any suggestions about how I might go about this?
Should this be done with a trigger, stored procedure or is there someway to handle through the defaults on the table. Thanks.
Have a status column at User table if datediff(day,DateColumn,getdate())>=90
—Update status column to Disable
Madhivanan Failing to plan is Planning to fail
I think he is refering to the SQL user login
If you hhave windows authentication you can automaticlly do this.
But I am not sure with SQL Server authentication
quote:Originally posted by artfuldodger
I need to disable a user’s login after 90 days. The userid and password are stored in a user table. Any suggestions about how I might go about this?
Should this be done with a trigger, stored procedure or is there someway to handle through the defaults on the table. Thanks.
I need to disable a user’s login after 90 days. The userid and password are stored in a user table. Any suggestions about how I might go about this?
Should this be done with a trigger, stored procedure or is there someway to handle through the defaults on the table. Thanks.
True and if Mixed mode is used then Madhivanan’s method is ideal. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>