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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-21 : 10:35:30
|
| Brett writes "Hi!I would like to be able to give one of my users access to Enterprise Manager, so that he can view, create and run his own jobs.The types of jobs that he will run DO NOT invole altering any data, just various queries that he wants to schedule to run.I would like to keep his permissions on the database as 'readonly'. Is it possible to set up a database role that has the ability to use jobs in Enterprise Manager without giving him admin rights to the database itself?Thanks for any help that you can give me on this.CheersBrett" |
|
|
Kevin Snow
Posting Yak Master
149 Posts |
Posted - 2002-08-22 : 15:50:36
|
| I set up a SQL account on 2000, with access to a single database as DATAREADER. It allowed me to create certain jobs and execute them as you indicated.The account could only view the jobs it had created. Other jobs owned by the admin were invisible to the user in EM. Make sure that the user registers the server under his/her own security. |
 |
|
|
|
|
|
Security role to view, run, create jobs in eneterprise mgr