JOB creation permission

Hi,
How can I prevent a user from creating a Sql Agent Job?
Thanks,
AlanA.M wrote:
> Hi,
> How can I prevent a user from creating a Sql Agent Job?
> Thanks,
> Alan
Get them out of the server role that's giving them rights or explicity
revoke them. If they're an administratot they already have full rights.
What group does the user belong to?
Exec sp_helpuser '<name>' -- current db
EXEC sp_helplogins '<name>'
Exec sp_helpsrvrolemember
David Gugick
Imceda Software
www.imceda.com|||Unfortunately, there's a guest user in msdb. Also, EXEC permissions is grant
ed on sp_add_job (etc)
to public in msdb. Remove any of these (just think it through which one is b
est in your
environment). Adding the login to msdb as an explicit user and DENY on sp_ad
d_job is also an option.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"A.M" <nospam1@.online.nospam> wrote in message news:OTFqXptEFHA.2828@.TK2MSFTNGP09.phx.gbl..
.
> Hi,
> How can I prevent a user from creating a Sql Agent Job?
> Thanks,
> Alan
>