SQL Server 2000 Job level premission?# Database - 数据库
a*t
1 楼
Is it possible to control Job view/execution premissions at the SQL Server
Agent Jobs level?
If so, how do I do that?
Agent Jobs level?
If so, how do I do that?
x*e
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 的大作中提到】
: 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
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?
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
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.
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
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?
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?
相关阅读
oralce8 and UTF8 support急！！！Why SQL Server 7 Enterprise Manager is so slow?SQL Server的DTS?How to import database into MySQL?which part to install for Oracle8i for 98?怎样在T-SQl中执行一条放在varchar中的命令HELP! need info on QBE(Query By Example)How to query a tree600了I'm waiting for your oraclenewbie's question about oracleMySQL: cannot connect有哪些关于软件资格与水平考试的网站？JustRe: [转载] somebody posted the junklegacy system急！ 急！向sybase表中插入数据不好用？~{Gk=L~} CS expert !!!how to get primary key through JDBC?