What are the minimum permissions required for a user to successfully connect and use a SQL project database with promis.e or Bentley Substation?

Background

This article is intended for SQL server administrators.

When the ecaduser login is created by the software or a login is created with the script provided in the SQL Server Login article, the login will be a member of the public server role and the db_owner and public database roles.

Alternatively, the db_datareader and db_datawriter database roles can be assigned instead of db_owner, as described below.

Steps to Accomplish

1. In SQL Server Management Studio, connect to the server. SQL Management Studio if not installed on your machine then follow the Wiki Link Install SQL Server Management Studio for the details steps for installing SQL Management Studio.
   
   
   
   
2. In the Object Explorer tree expand Security > Logins.
   
   
3. Create the login if it does not already exist by Right Click on Login and Select New Login.
   
   
   
   
4. If need to make changes to existing Login, Right-click the existing User login and select Properties.
   
   
   
   
5. On the Server Roles page enable the following:
   • public
     
     
     
     
6. On the User Mapping page, select the database used by the software in the Database column. Specify "dbo" in the Default Schema column.
   
   
   
   
7. In the "Database role membership" area enable:
   • db_datareader
   • db_datawriter
   • public
   Or enable:
   • db_owner
   • public
   Disable:
   • db_denydatareader
   • db_denydatawriter
     
     
     
     
8. Click OK.
   
   
9. Right-click the project database in the Object Explorer tree and select Properties.
   
   
   
   
10. Select the Permissions page.
    
    
11. Select the user in the top pane.
    
    
12. Check the box in the Grant column for the Execute permission in the bottom pane.
    
    
    
    
13. Click OK.

See Also

SQL Server Login

Exception thrown when creating a project due to SQL permissions

Keywords: rights, requirement, restricted, limited