Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenGround | gINT | Keynetix
  • Product Communities
OpenGround | gINT | Keynetix
gINT | Keynetix Wiki Setting Up Access Levels in a SQL Database
    • Sign In
    • -gINT | Keynetix Wiki
      • -gINT
        • Subscription Entitlement Service Benefits for gINT Users
        • Downloading and Installing gINT
        • +The gINT Files
        • +gINT Help, Tips and Tricks, and FAQs
        • -gINT Professional Plus
          • -Data Entry - gINT Professional Plus
            • Create a Project Filter for Input
            • How do I convert northing/eastings to latitude/longitude or vice versa? Coordinate Conversion FAQs
            • Setting Up Access Levels in a SQL Database
          • gINT SQL Network Performance Best Practices
          • +Project Database - gINT Professional Plus
          • +Report-Log - gINT Professional Plus
        • Report-Fence
        • +Report-Log
        • +Downloads: Free Reports and Examples
        • +Geotechnical White Papers and Articles
        • +gINT for ArcGIS Toolbar
        • +How-To FAQs
        • +Things You Can Do In gINT
        • +Troubleshooting gINT
        • Videos on gINT and subsurface data topics
        • +Tutorials
        • gINT User Guides
        • Learning with gINT - On Demand
        • Working from home with gINT
      • +gINT Collector
      • +gINT Civil Tools
      • +Keynetix

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

    Setting Up Access Levels in a SQL Database


       
      Applies To 
       
      Product(s): gINT Professional Plus
      Version(s): N/A
      Environment:  Microsoft SQL Server
      Area:  Data Entry
      Subarea: 
      Original Authors:

    Dave Anderson, Bentley Software;
    Kathleen Holcomb, Bentley Technical Support Group

       

     

    We wish to limit what some users can do in our gINT SQL enterprise database.  For example, some users should be able to view data and output reports, but not change the data.  Other users should be able to edit data but not modify the database.

    Introduction

    Microsoft SQL Server allows you to control what kind of access you give to users.  

    You can use either Windows or SQL Server authentication. Our example server uses Windows authentication.

    In this example, we will establish 3 levels of user permissions:

    • Administrator: can modify, upsize, and read and write to any database.
    • Update User: can read and write to selected databases.

    • Read-Only User: can only read selected databases.

    Steps to Accomplish

    Connect to the SQL database

    1. Connect to a SQL Server instance: 

    2. Navigate to Security Logins:

    3. Create or Select a User.

    4. Right-click on a user and select New Login…

    5. Right-click on a user and select Properties.

    Administrative User: 

    1. Select Server Roles.  Check public and sysadmin.

    2. User Mapping: not necessary to select anything given the sysadmin authority.

    Read-Write User:

    1. Select Server Roles.  Check public.

    2. Select User Mapping. Check the databases that the user can access.  Check the roles db_datareader, db_datawriter and public:

     Read-Only User (qa3): 

    1. Select Server Roles.  Check public.
    2. Select User Mapping. Check the databases that the user can access.  Check the roles db_datareader and public.

    See Also

    gINT V8i Enterprise User Guide: ftp://docs.bentley.com/pub/dl/pdfs/en/gINT_enterpriseuserguide_v8_30.exe

    • data entry
    • Permissions
    • Enterprise
    • gINT Professional Plus
    • Rights
    • how to
    • SELECTsupport
    • Share
    • History
    • More
    • Cancel
    • Kathleen Holcomb Created by Kathleen Holcomb
    • When: Wed, Jun 4 2014 7:53 PM
    • Kirk Johnson Last revision by Bentley Colleague Kirk Johnson
    • When: Thu, Feb 18 2021 1:57 PM
    • 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