EMS logo

Products Navigation

SQL Manager for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for SQL Server

On-line Documentation

Server-level principals


Principals are individuals, groups, and processes that can request SQL Server resources.

 

SQL Manager for SQL Server provides management tools for the following server-level security principals:

 

Logins

Allows you to manage SQL Server logins.

 

Server Roles Manager

Allows you to manage SQL Server roles.

 

 

Adding Logins

 

In order to add a new login:

  • select the Tools | Login Manager main menu item or use the corresponding btnLoginManager toolbar button to open Login Manager;
  • select the Add login... item of the context menu or within the Navigation bar;
  • define login properties and permissions using Login Editor

or

  • right-click the Logins node (Server Objects) or any object within this node in DB Explorer and select the New Login context menu item, or use the Ctrl+N shortcut;
  • define login properties and permissions using Login Editor.

 

Editing Login Properties

 

In order to edit an existing login:

  • select the Tools | Login Manager main menu item or use the corresponding btnLoginManager toolbar button to open Login Manager;
  • select the Edit login... item of the context menu or within the Navigation bar;
  • edit the login properties and permissions using Login Editor

or

  • right-click the Logins node (Server Objects) or any object within this node in DB Explorer and select the Edit Login <object_name> context menu item, or use the Ctrl+O shortcut;
  • edit the login properties and permissions using Login Editor.

 

Deleting Logins

 

In order to delete an existing login:

  • select the Tools | Login Manager main menu item or use the corresponding btnLoginManager toolbar button to open Login Manager;
  • right-click the login to delete and select the Delete Login item of the context menu or within the Navigation bar;
  • confirm deleting in the dialog window

or

  • right-click the login to delete within the Logins node (Server Objects) in DB Explorer and select the Drop Login <object_name> context menu item, or use the Shift+Del shortcut;
  • confirm deleting in the dialog window

 

Allocating Server Roles

 

In order to allocate server roles to logins:

  • select the Tools | Server Roles main menu item or use the corresponding btnServerRoles toolbar button;
  • select a server role, and add logins to the Server Role Members list using Server Roles Manager.

 

 


See also:

Server Log Viewer

Activity Monitor

Resource Governor