Login Management

Previous  Top  Next

The Login Manager is an easy to use tool. Simply double click the Login Manager node in the Enterprise Manager and the Login Manager will open.

 

The Login Manager

 

Selecting a login and using the Edit Login button will open the Login Properties dialog.

 

The Login Properties Dialog

 

If you create a new login, this dialog will appear as well - but empty of course.

 

Once you have created a login, you can't change every option available - for the meaning of the different options, please check the MS SQL Server documenation.

 

The Server Roles tab let's you add/delete the login from a fixed server role.

 

Login Properties - Server Roles

 

By checking or unchecking the server role name at the left part of the screen, you'll add or remove a login to or from that role. At the right, there's a list of actions that the role member can perform. The bottom part of the screen holds a quick description for the role, these descriptions come from MS SQL Server itself and cannot be changed.

 

Exitting this dialog by using the OK button will save the login information.