Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenUtilities
  • Product Communities
OpenUtilities
OpenUtilities Wiki Minimum SQL user permission for Promis.e users - OpenUtilities Substation CONNECT
    • Sign In
    • +OpenUtilities
    • Access Service Request Manager
    • +Bentley sisHYD Multi Utility
    • Design Features - promis.e Functionality - Promis.e Standard
    • +OpenUtilities sisNET - English
    • -OpenUtilities Substation
      • -CONNECT Edition - OpenUtilities Substation
        • +3D Layout Features - OpenUtilities-Substation
        • +Administration Features - OpenUtilities Substation
        • +Automation Feature
        • +Component management - OpenUtilities Substation CONNECT
        • +Components Features - Substation CONNECT
        • +Construction Drawing - Openutilities Substation CONNECT
        • -Database Platform Support - OpenUtilities Substation
          • Creating and Updating the Project Database - Substation CE
          • How to Migrate from Old SQL Server to New SQL Server for OpenUtilities Substation CONNECT
          • How to resolve "Transaction log is full" error while deleting Projects
          • Installing SQL Server Express locally for OpenUtilities Substation CONNECT
          • Project Database SubVersion - OpenUtilities Substation
          • -SQL User Permissions - OpenUtilities Substation CONNECT
            • Error "In order to create the database you must have the 'sysadmin' role permission" - OpenUtilities Substation CONNECT
            • Minimum SQL user permission for Promis.e users - OpenUtilities Substation CONNECT
          • Updating Database for OpenUtilities Substation CONNECT Update 10 and through
        • +Drawing Managment - OpenUtilities Substation
        • +Installation_Configuration - Bentley Substation CONNECT Edition
        • +Maintenance Feature - Open Utilities Substation CONNECT
        • +Migration - OpenUtilities Substation CONNECT
        • +OS & Hardware Support - OpenUtilities Substation CONNECT
        • +Panel Layout- Substation CONNECT
        • +Power Platform Support - Substation CONNECT
        • +Print and Plot feature
        • +Print and Publish feature
        • +Project Management - OpenUtilities Substation CE
        • +ProjectWise Integration - OpenUtilities Substation CONNECT
        • +Replace Device ID - Find_Replace - OpenUtilities Substation
        • +Reports_Output Features - OpenUtilities Substation CONNECT
        • +Resolved issues in OpenUtilities Substation Releases
        • +Wire Numbering - Substation CONNECT
        • +Wiring Feature - OpenUtilities Substation
      • +3D Layout Features - Bentley Substation
      • About Bentley Substation
      • +Administration Features - Bentley Substation
      • +Automation Features - Bentley Substation
      • +Component Management - Bentley Substation
      • +Construction Drawings - Bentley Substation
      • +Database Platform Support - Bentley Substation
      • +Grounding Grid - Bentley Substation
      • How to log Service Request
      • +Installation_Configuration - Bentley Substation
      • +Interoperability - Bentley Substation
      • +PowerPlatform Support - Bentley Substation
      • +Project Management - Bentley Substation
      • +ProjectWise Integration - Bentley Substation
      • Working from home with OpenUtilities Substation
    • Promis.e Paths
    • +Promis.e Wiki
    • Replace Family - Find_Replace - Promis.e
    • SQL Server Login

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

    Minimum SQL user permission for Promis.e users - OpenUtilities Substation CONNECT

      Product(s): OpenUtilities Substation CONNECT Edition
      Version(s):  10.00.XX.XX to 10.13.XX.XX
      Environment:  NA
      Area:  Database Platform Support
      Subarea:  SQL Permission

    Background:

    What are the minimum permissions required for a user to successfully connect and use a SQL project database with OpenUtilities Substation (OUS) CONNECT? 

    This article is to help New Users or SQL/Database Administrators to create/update SQL Server Login for users to connect with OUS Project Database.



    Steps to Accomplish

    1. In SQL Server Management Studio, connect to the server where the OUS Project Database is located. If you dont have SQL Server Management Studio(SSMS) installed you can download and install it from below link. 





    2. In the Object Explorer tree expand Security > Logins right click > New Login if the user dose not already have a login and go to step 4. If the Login for the user exists then go to Step 3.




    3. For the user who already has a login Expand Logins > select the User and Right Click > Properties. 




    4. Then if the user account new select all the required details in General and then go to Server Roles and check Public.



    5. On the User Mapping page, select the database used by the software in the Database column. Specify "dbo" in the Default Schema column.



    6. In the User Mapping's "Database role membership for" check the below options and click OK.

    db.datareader 
    db.datawriter

    or 

    db.owner


    Also see

      Original Author: Satish Saptasagar
    • Database Platform Support
    • user permission
    • en
    • Database
    • OpenUtilities Substation
    • Share
    • History
    • More
    • Cancel
    • Satish Saptasagar Created by Bentley Colleague Satish Saptasagar
    • When: Wed, Jan 4 2023 5:56 AM
    • Revisions: 1
    • 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