KBI 311912 User Privileges Required To Execute Argent Job Scheduler GUI
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.
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
- Open SQL Server Management Studio and connect to correct data base
- Security > Users > Select correct user
- Under Owned Schemas
- Select db_datareader
- Select db_datawriter
- Verify db_denydatareader is not selected
- Verify db_denydatawriter is not selected
- Under Membership
- Select db_datareader
- Select db_datawriter
- Verify db_denydatareader is not selected
- Verify db_denydatawriter is not selected