Redigera

Dela via

Granting Permissions to Manage Business Central Databases in SQL Server

  • Artikel

Special permissions are required in SQL Server to create and manage Business Central databases, for example by using Business Central Administration Shell or development environment. To grant these permissions to Business Central administrators, use SQL Server Management Studio.

Permissions for using and creating databases

The administrator who installs Business Central automatically has access to the database. To give another user permission to create new databases, grant that user the dbcreator Server Role for the Business Central SQL Server instance in SQL Server Management Studio.

Note

The administrator must also have a Business Central developer's license to use the development environment, and be assigned the SUPER permission set.

In the Object Explorer pane in SQL Server Management Studio, follow these steps after connecting to the Business Central SQL Server instance:

  1. Expand the Security node, right-click Logins, and select New Login.

    If the administrator already has a login, right-click the user and select Properties. Then go to step 4.

  2. In the Login – New dialog box, select Search.

  3. In the Select User or Group dialog box, select a valid Active Directory user.

  4. In the Login – New dialog box, under Select a Page, select Server Roles. Select the dbcreator check box.

  5. Select the OK button to close the Login – New dialog box.

When administrators create Business Central databases, the account running Business Central Server is automatically granted the db_owner database role for these databases.

Permissions for managing companies, objects, and licenses

Administrators who create Business Central databases automatically have permission to manage companies, objects, and licenses in that database.

To grant permission to manage companies, objects, and licenses to additional administrators, assign those administrators the db_owner database role for all relevant Business Central databases.

To grant the db_owner role on a Business Central database in SQL Server Management Studio, follow these steps:

  1. If the administrator is not already a SQL Server login, add the administrator as a login by following the first three steps in the procedure above.

  2. Select the Business Central database, then Security, then right-click Users and select New User.

    Select the button at the right of the Login Name field to open the Select Login dialog box.

  3. Select the Browse button, select the check box for the relevant login, and then select the OK button.

  4. Select the OK button to exit the Select Login dialog box.

  5. Enter a User name for the user.

    This value can be the same as the login name.

  6. In the Database User - New dialog box, under Select a Page, select In the Database role membership.

  7. Select the db_owner check box.

  8. Select the OK button to exit the Database User – New dialog box.

Installation considerations for Microsoft SQL Server
Security and protection