Admin Tool for Secure Database Management

SQL Server administration is a complex process directed to maintaining a reliable database environment. Controlling database security requires working with user accounts and logins, as well as granting and manipulating permissions and roles. Proper user accounts administering ensures the profitable work of the whole company.

In order to manage your database with high performance and reliability, dbForge Studio for SQL Server is supplied with a powerful SQL administration tool that meets the requirements of today's high-level admin tools.

Security Manager is a professional SQL Server administration tool built into dbForge Studio for SQL Server that helps you protect your data, and organize and automate routine SQL administration tasks in the most secure and effective way. With Security Manager, you can:

  • Create, update, or delete logins, users, roles, application roles, and schemas
  • Manipulate and duplicate user accounts
  • Assign, modify, or delete roles visually without writing a SQL code
  • Grant object permissions and revoke user privileges
  • Assign user permissions
  • Manage access rights and privileges

Creating User Accounts and Logins

With the help of the admin tool you can easily and quickly add, modify, and remove user accounts instead of typing the whole SQL code. To create a new login or user account, do the following:

  1. On the Database menu, click Security Manager.
  2. From the Create drop-down list, select either Create Login to create a new login or Create User to create a new user.
  3. Specify the required parameters and click Save.
Security Manager: Creating Logins and User Accounts

Assigning Roles

Roles are well suited for the work of SQL database administrators when the whole privilege set is added to a user at once. To assign a role to the database, do the following:

  1. On the Database menu, click Security Manager.
  2. From the Create drop-down list, select Create Role.
  3. Add a name of the role and select the owner.
  4. Select owned schemas, role members, and object permissions.
  5. To keep the changes, click Save.
Security Manager: Assigning a Role

Granting/Revoking Permissions on Database Objects

On the Object Permissions tab of the Security Manager, you can grant or revoke the permissions on objects. Available permissions for database objects are displayed once you have chosen an object you want to grant the permissions to. To grant a user with permissions on database objects, do the following:

  1. On the Database menu, click Security Manager.
  2. Choose the user you want to grant permissions to or create a new user, and then switch to the Object Permissions tab.
  3. In the Objects tree, select the database object you want to view the permissions for. The granted permissions will be selected in the Available Privileges list.
  4. To add or remove the permission, select or clear the privilege in the Available Privileges list respectively.
  5. To keep the changes, click Save.
Security Manager: Granting Permissions on Database Objects