User accounts that are used to transfer data must be granted certain roles and permissions.
-
Grant the user the mon_role role.
-
Grant the user the js_admin_role role.
-
Grant the user all permissions to the model.dbo.spt_TableTransfer table.
-
Grant the user select permissions to the sybmgmtdb.dbo.js_callouts and sybmgmtdb.dbo.js_jobs tables.
-
Grant the user all permissions to the derived data tables.