Create a SQL API User Application Control

This activity describes how to create a user, map it to a database, and assign the db_owner role in SQL Server using SQL Server Management Studio (SSMS).

Activity Steps

1. Open Server Management Studio (SSMS).

   The Connect to Server window displays.

2. Enter the following Server details:
   • Server type
   • Server name
   • Select the Authentication method. If required, enter your login credentials.
3. Enter the following Connection Security details:
   1. Select the Encryption type.
   2. Select whether to Trust server certificate.
   3. If Strict is selected as the Encryption type, enter the Host name in certificate.
4. Click Connect.

   The database nodes display in the Object Explorer window.

5. Expand the Security folder.
6. Right-click the Logins folder and select New Login... from the context menu.

   The Login - New window displays.

7. Select the General page.
   1. Enter the Login name.

      Note: The user does not need to exist in the Fusion database.

   2. Select from either SQL Server authentication or Windows authentication.
   3. If SQL Server authentication is selected, enter a Password and Confirm password.
   4. Select whether to Enforce password policy.
8. Select the Server Roles page.
9. Select the relevant Server roles for the user.
10. Select the User Mapping page.
    1. In the Users mapped to this login section, check the Database the user should have access to.
    2. In the Database role membership for the database, check db_owner and any other relevant roles for the user.
11. Click OK.
12. To verify that the user was created:
    1. In the Object Explorer, expand the Databases.
    2. Expand the node of your database.
    3. Expand Security.
    4. Expand Users.

       The new user displays.