Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pixelmonkey
Starting Member
2 Posts |
 Posted - 2012-05-22 : 10:06:51
|
| first post on this forum.this should be easy.DB with users has a date stamp for when they last logged on.format = 2010-02-19 08:31:48.877I need to have the user accounts locked if they have not logged onto the system in the last X number of days.nothing further required, just lock the account.help?thankschris<pixelmonkey>:D |
|
|
pixelmonkey
Starting Member
2 Posts |
Posted - 2012-05-31 : 13:27:33
|
| bumpchris<pixelmonkey>:D |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
lock inactive user accounts after X days