KBI 310947 Minimum DB Rights Required By Argent AT User

Version

Argent Advanced Technology all versions

Date

Wednesday, 28 May 2014

Summary

Assuming Windows authentication is used, to configure a non-admin user to use Argent AT, following minimum DB rights should be assigned:

  1. Add the Windows account or user group as SQL Server Login

    (Windows account A\TEST1 is used in the example)

  2. Bring up Login Properties dialog box, and assign Server Roles ‘public‘




    3. Click For Full Size

  3. Go to User Mapping, give default schema ‘dbo‘ for Argent AT database

  4. Assign rights of db_datareader, db_datawriter and public




Click For Full Size

After above is completed, logon as the Windows account, and start up Argent AT main GUI to verify everything works as expected




Click For Full Size

Technical Background

N/A

Resolution

N/A