KBI 310947 Minimum DB Rights Required By Argent AT User


Argent Advanced Technology all versions


Wednesday, 28 May 2014


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. Go to User Mapping, give default schema ‘dbo‘ for Argent AT database
  4. Assign rights of db_datareader, db_datawriter and public

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

Technical Background