You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
SQL Server Limited User

Applies to

  • Access It! Universal.NET Versions 5.5 - 7.x

Overview

Beginning with Access It! Universal.NET version 5.5, a limited SQL account can be created within the Database Configuration Utility. This limited account will have the minimum permissions required to run Access It! Universal.NET

Automatic Implementation

  1. On the Server machine, browse to Start | Programs | Access It! Universal.NET | Utilities and open the Database Configuration Utility 
  2. Connect to the SQL Server using an account with administrative permissions to the AIUniversal database as well as SQL Server
  3. Once connected, select Create Limited User from the File menu
  4. Enter the new users username and password
  5. Click OK
  6. Close the Database Configuration Utility
  7. Reopen the Database Configuration Utility
  8. Connect to the SQL Server using the newly created limited SQL account
  9. Once connected, close the Database Configuration Utility
  10. If running, close Access It! Universal.NET 
  11. Browse to Start | Programs | Access It! Universal.NET | Utilities and open the Service Manager 
  12. Stop the Access It! Universal.NET service 
  13. Restart the Access It! Universal.NET service 

Manual Implementation

If it's desired for a limited account to be manually created, the following permissions are the minimum necessary to run Access It! Universal.NET.

  • Server Role of dbcreator permission granted to login
  • User Mapping of dbreader and dbwriter permission to AIUniversal database, as well as any AIUEvents databases
  • Grant ability to create functions, tables, procedures, and views within AIUniversal database
  • Grant access to Events_Insert stored procedure within AIUniversal database
  • Grant access to vwEvents and vwEvents_Composite views with AIUniversal database
  • Grant access to dbo schema
  • Grant ability to execute all stored procedures within the AIUniversal databases, as well as any AIUEvents databases

Feedback
0 out of 0 found this helpful

scroll to top icon