asked on
Are there any security risks adding user to MSDB database and giving them permissions to execute agent jobs?
Are there any security risks adding user to MSDB database and giving them permissions to execute agent jobs?
Microsoft SQL Server 2005Microsoft SQL Server 2008Microsoft SQL Server
Last Comment
EvilPostIt
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Im a DBA so yes.
Sorry that sounded quite blunt. Appologies for that.
ASKER
no problem... i'm just am SQL idot!!!
ASKER
thanks
ASKER
I just read on http://msdn.microsoft.com/en-us/library/ms188283.aspx
The SQLAgentReaderRole and the SQLAgentOperatorRole are automatically members of the SQLAgentUserRole.
Should I deny permission on SQLAgentReaderRole and the SQLAgentOperatorRole as well?
The SQLAgentReaderRole and the SQLAgentOperatorRole are automatically members of the SQLAgentUserRole.
Should I deny permission on SQLAgentReaderRole and the SQLAgentOperatorRole as well?
See what the DBA's say. If they arent bothered about then dont worry.
From a dba perspective do you think they would be happy with this setup?