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.
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:
Update User: can read and write to selected databases.
Read-Only User: can only read selected databases.
Navigate to SecurityLogins:
Create or Select a User.
Right-click on a user and select New Login…
Right-click on a user and select Properties.
User Mapping: not necessary to select anything given the sysadmin authority.
Select Server Roles. Check public.
Select User Mapping. Check the databases that the user can access. Check the roles db_datareader, db_datawriter and public:
Select User Mapping. Check the databases that the user can access. Check the roles db_datareader and public.
gINT V8i Enterprise User Guide: ftp://docs.bentley.com/pub/dl/pdfs/en/gINT_enterpriseuserguide_v8_30.exe