What are the minimum permissions required for a user to successfully connect and use a SQL project database with promis.e or Bentley Substation?
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 Creating an 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.
Creating an SQL Server Login
Exception thrown when creating a project due to SQL permissions
Keywords: rights, requirement, restricted, limited