How to allow non-sa to modify a job? - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

How to allow non-sa to modify a job?

How to allow non-sa to modify a job?# Database - 数据库

a*t2008-01-15 08:01

1 楼

SQL 2005
Is there a way to allow non-sysadmin to modify jobs they don't own from the
management studio interface? (or from system stored procedures for that
matter)
Even the most privileged SQLAgentOperatorRole does not allow this...
Thanks

w*e2008-01-15 08:01

2 楼

偶记得好象SQL2000里可以...
(not sure though)

the

【在 a*******t 的大作中提到】

: SQL 2005
: Is there a way to allow non-sysadmin to modify jobs they don't own from the
: management studio interface? (or from system stored procedures for that
: matter)
: Even the most privileged SQLAgentOperatorRole does not allow this...
: Thanks