Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenUtilities
  • Product Communities
OpenUtilities
OpenUtilities Wiki Minimum SQL user permissions
    • Sign In
    • +OpenUtilities
    • Access Service Request Manager
    • +Bentley sisHYD Multi Utility
    • Design Features - promis.e Functionality - Promis.e Standard
    • +OpenUtilities sisNET - English
    • +OpenUtilities Substation
    • Promis.e Paths
    • -Promis.e Wiki
      • +CONNECT Edition - Promis.e
      • About Promis.e
      • +Administration Features - Promis.e
      • +APIs_VBA - Promis.e
      • +Automation Features - Promis.e
      • +Component Features - Promis.e
      • +Component Management - Promis.e
      • +CONNECT Services - Promis.e
      • +Data Manager - Promis.e
      • -Database Platform Support - Promis.e
        • Backing Up Promis.e Data Automatically
        • Converting to an SQL Parts Database
        • +Creating and Updating the Project Database
        • Desired SQL server Not Listed in the available Servers List
        • Disable Auto Shrink to avoid performance degradation
        • Error - Could not find SQL Server instance named BENTLEYECAD
        • Error - Could not find stored procedure
        • Error - Database version does not match the application
        • Error - Index was outside the bounds of the array (Microsoft.SqlServer.smo)
        • Error - Invalid database name - on Project Database Utility
        • Error - Invalid object name
        • Error - Login failed for Ecaduser: Reason: The Password of the account Expired
        • Error - No version resource could be located in database
        • Error - OraOLEDB.Oracle provider is not registered
        • Error - T-SQL execution command line utility stopped working
        • Error - The database is for product... you cannot use it
        • Error at Startup - Error 0 No connection could be made because the target machine actively refused it.
        • Error at Startup - Error 40 Could Not Open a Connection
        • Error at startup - The Type initializer for ECT.ECAD.API.SystemSetup threw an exception
        • Error at Startup - Unrecognized database format, catalog.mdb
        • Error deleting project - transaction log full
        • Error messages encountered due to case sensitive collation of SQL Server
        • Error on backup - Invalid database object reference
        • Error on Project Database Utility - Cannot find the file specified
        • Error running SQL scripts - Incorrect syntax
        • Exception thrown when creating a project due to SQL permissions
        • Exception thrown when opening a page, transaction log is full
        • Finding the SQL Data folder
        • Installing SQL Server
        • Minimum SQL user permissions
        • Project Database Version - Promis.e
        • Rebuild indexes in the SQL project database
        • Rules for Regular Identifiers
        • SQL Server FAQ
        • Troubleshooting Project Database Connection Problems
      • +Display - Promis.e
      • +Drawing Management - Promis.e
      • +Engineering Design Considerations - Promis.e
      • Error - Object reference...General
      • +Find_Replace - Promis.e
      • Finding the Tutorial
      • +Installation_Configuration - Promis.e
      • +Interoperability - Promis.e
      • +Licensing - Promis.e
      • +Maintenance Features - Promis.e
      • +Migration - Promis.e
      • +OS Support - Promis.e
      • +Panel Layout - Promis.e
      • +Performance - Promis.e
      • +PowerPlatform Support - Promis.e
      • +Print_Publish Features - Promis.e
      • +ProjectWise Integration - Promis.e
      • Promis.e Help file
      • +Reports_Output Features - Promis.e
      • +Template Management - Promis.e
      • +Text Tools - Promis.e
      • Training FAQs
      • +Wire Numbering - Promis.e
      • +Wiring Features - Promis.e
      • +Project Management - Promis.e
      • Promis.e Title
      • Working from home with Promise.e
    • Replace Family - Find_Replace - Promis.e
    • SQL Server Login

     
     Questions about this article, topic, or product? Click here. 

    Minimum SQL user permissions

      Product(s): Promis.e, Bentley Substation
      Version(s): through 08.11.13.73
      Environment: N\A
      Area: Database Platform Support
      Subarea: N/A

    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

      Original Author: Matt_P

     

    Keywords: rights, requirement, restricted, limited

    • Database Platform Support
    • promis.e
    • SQL Server
    • user permission
    • Bentley Substation
    • en
    • SELECTsupport
    • Share
    • History
    • More
    • Cancel
    • Matt_P Created by Communities MVP Matt_P
    • When: Tue, Aug 11 2015 3:16 PM
    • Satish Saptasagar Last revision by Bentley Colleague Satish Saptasagar
    • When: Thu, Oct 3 2019 6:18 AM
    • Revisions: 10
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies