Perform the following steps on the Isogen Web API database server.
-
Open Microsoft SQL Server Management Studio, and then expand the listing for your database server in the left tree view.
-
In the tree view, expand the listing under Security, right-click Logins, and then select New Login to open the Login - New dialog.
-
Type the user account to be assigned administrative privileges in the Login name text box. For example, type AdminUser1.
-
Select Server Roles under the Select a page heading to display the Server Roles list.
-
In the Server Roles list, select the sysadmin check box.
-
Administrators need the sysadmin role. Standard users need public, db_datareader, and db_datawriter database role membership mapping to each one of the Isogen Web API databases. Standard users also need Execute permission to each database.
-
PPM does not recommend giving standard users db_owner permissions as it gives the users a very high privilege to the database.
-
-
Click OK.