Deactivate a User Account
You can deactivate a user account so that the user no longer has access to Vista.
- account settings in the VA User Profile form
- activity history throughout the system
- deactivation date.Note: Deactivation dates are reported in the VA Systems User report, using the Detail option.
Users who happen to be logged in at the time their account is deactivated are not automatically logged out. However, once they've logged out, they are prevented from logging back in with the same account.
- Deny user access to the MS SQL Server database. The software you use to manage your SQL server may require you to deviate from the instructions in this part.
- Deactivate the user record in Vista.
Re-activating the user account requires the reversal - clearing the Deactivated check box and saving the user record, then restoring access to the MS SQL Server database.
- Using an administrator login, open a connection to your Microsoft SQL Server.
- Locate your server and select the appropriate Database directory.
- In the database from which you are removing the user's access, expand the Logins folder.
- In the Logins folder, locate and right-click the user account you want to deactivate.
- In the context menu, select Properties.The Login Properties dialog box opens.
- In the Login Properties dialog box, click the General tab.
- In the Password and Confirm Password fields, change the password.
- In the Login Properties dialog box, click the Status tab.
- In the Permissions field, select Deny.
- In the Login field, select Disabled.This completes the first part - denying user access to the database.
- In Vista, open the VA User Profile form.
- In the Info tab, select the user record and select the Deactivated checkbox.
- Click Save.