User accounts that are used to truncate 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 select permissions to the sybmgmtdb.dbo.js_callouts and sybmgmtdb.dbo.js_jobs tables.
-
Grant the user all permissions to the market and derived data tables.