Granting RAPCache Database User Account Permissions

User accounts that are used to transfer data must be granted certain roles and permissions.

  1. Grant the user the mon_role role.
  2. Grant the user the js_admin_role role.
  3. Grant the user all permissions to the model.dbo.spt_TableTransfer table.
  4. Grant the user select permissions to the sybmgmtdb.dbo.js_callouts and sybmgmtdb.dbo.js_jobs tables.
  5. Grant the user all permissions to the derived data tables.
Related tasks
Granting RAPCache Database User Permissions
Related reference
Creating User-Defined Execution Classes
Creating User-Defined Execution Classes