1回答
- 新しい順
- 投票が多い順
- コメントが多い順
0
If anyone encounters the same issue, I've changed the SELECT calls to the tables to use instead the available store procedures which any user with the SQLAgentUserRole is allowed to execute.
For example, instead of selecting rows from dbo.sysjobsteps
table, calling the msdb.dbo.sp_help_jobstep
store procedure returns the necessary information.
回答済み 2年前
関連するコンテンツ
- 質問済み 6年前