a*******t
发帖数: 891 | 1 Is it possible to control Job view/execution premissions at the SQL Server
Agent Jobs level?
If so, how do I do that? | x***e
发帖数: 2449 | 2 Any reason you want to do that?
【在 a*******t 的大作中提到】
: Is it possible to control Job view/execution premissions at the SQL Server
: Agent Jobs level?
: If so, how do I do that?
| a*******t
发帖数: 891 | 3 for security request
I've looked it up and seems like there is no built-in way in SQL 2000. but
in 2005 there are three SQL Job Agent roles with different levels of
premissions.
【在 x***e 的大作中提到】
: Any reason you want to do that?
| x***e
发帖数: 2449 | 4 Not familier with 2005.
I am thinking, if you use the job to call DTS, SP, or other scripts,
and your job role is lower than the object, your job will fail.
So is it necessary for an additional security control?
【在 a*******t 的大作中提到】
: for security request
: I've looked it up and seems like there is no built-in way in SQL 2000. but
: in 2005 there are three SQL Job Agent roles with different levels of
: premissions.
| a*******t
发帖数: 891 | 5 requirement from the business units, to let some users view jobs without the
ability to run/modify them
may have to add some more Job roles manually
【在 x***e 的大作中提到】
: Not familier with 2005.
: I am thinking, if you use the job to call DTS, SP, or other scripts,
: and your job role is lower than the object, your job will fail.
: So is it necessary for an additional security control?
|
|
