November 19, 2009 at 6:06 pm
Is there any way I can RESTRICT my database users access in SQL Server Agent Jobs?
Thanks.
November 19, 2009 at 7:08 pm
isabel-1114008 (11/19/2009)
Is there any way I can RESTRICT my database users access in SQL Server Agent Jobs?Thanks.
Let me rephrase this and understand more of your questions, because just jumping on seeing some part of the question and assume the rest is not going to solve purpose.
You want to restrict your Database Users using the SQL Agent Jobs, in other words database user should not able to access / see /start the SQL Agent Jobs.
Is that right?
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 19, 2009 at 7:41 pm
Bru Medishetty (11/19/2009)
isabel-1114008 (11/19/2009)
Is there any way I can RESTRICT my database users access in SQL Server Agent Jobs?Thanks.
Let me rephrase this and understand more of your questions, because just jumping on seeing some part of the question and assume the rest is not going to solve purpose.
You want to restrict your Database Users using the SQL Agent Jobs, in other words database user should not able to access / see /start the SQL Agent Jobs.
Is that right?
Yes sir. My database users should not be able to add, modify, or delete jobs.
November 19, 2009 at 8:23 pm
Use the script below
USE [msdb]
GO
EXEC sp_addrolemember N'db_denydatareader', N'UserName'
GO
USE [msdb]
GO
EXEC sp_addrolemember N'db_denydatawriter', N'UserName'
GO
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 19, 2009 at 10:40 pm
thanks bru! you solved my problem!
November 19, 2009 at 10:53 pm
isabel-1114008 (11/19/2009)
thanks bru! you solved my problem!
Glad I could help 🙂
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply