What SQL 2000 rights are required to create SQL Agent jobs?
It's been a long time since I looked at SQL jobs on SQL Server 2000.
In SQL 2005, if I want to allow the user to create jobs, etc., I add the required login to msdb and assign one of the roles to the role SQLAgentUserRole, SQLAgentReaderRole, or SQLAgentOperatorsRole. There is no problem.
Maybe someone can help me run through my memory of the rights / roles required to create jobs in SQL 2000 because I am embarrassed to say that I completely forgot and the SQL 2000 books on the internet are not very clear.
If the user is a dbo on a SQL 2000 database, does he automatically grant the rights to create SQL agent jobs?
source to share
Virtually every user can create a new SQL Server Agent job.
You have control over their rights to database objects. I just tried this and a user without any privileges (denydatareader and denydatawriter on all databases) can still create a new SQL Server Agent job, but it cannot do anything internally.
Hope this helps!
source to share