Version

Argent Job Scheduler – All Versions

Date

Wednesday, 17 February 2021

Summary

Users of Argent Job Scheduler GUI need to have db_datareader and db_datawriter access to data base in order for GUI to function properly

When accessing GUI the following error message will appear in GUI_LOG and a popup

Failed to initialize class information. Error: ODBC Error: The SELECT permission was denied on the object ‘AJS_JOBCLASS’, database ‘DB_NAME_HERE’, schema ‘dbo’.
The cursor was not declared.

Click For Full Size

Technical Background

By default Argent job Scheduler data base should not allow access to unknown users

Users of Argent Job Scheduler need to have db_datareader and db_datawriter access

Resolution

1. Open SQL Server Management Studio and connect to correct data base
2. Security > Users > Select correct user
3. Under Owned Schemas
   • Select db_datareader
   • Select db_datawriter
   • Verify db_denydatareader is not selected
   • Verify db_denydatawriter is not selected
     
     
     Click For Full Size
4. Under Membership
   • Select db_datareader
   • Select db_datawriter
   • Verify db_denydatareader is not selected
   • Verify db_denydatawriter is not selected
     
     
     Click For Full Size