Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2005-06-06 : 04:45:06
|
| I want to give READ ONLY access to DTS and Jobs to a user. Is it possible?------------------------I think, therefore I am - Rene Descartes |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-06-06 : 04:59:15
|
quote:
Originally posted by ravilobo
I want to give READ ONLY access to DTS and Jobs to a user. Is it possible?------------------------I think, therefore I am - Rene Descartes
probably restrict the public group at msdb, you should have removed the guest account at this point.job can only be started or modified by the owner and sadts can be restricted by setting the password for owner and userHTH--------------------keeping it simple... |
 |
|
|
|
|
|
Read only access to DTS and Jobs