Sunday, February 19, 2012

GK - Granting on all objects but not on JOBs ???

Hi,
I just wonder why I can grant / revoke on all objects ( tables, stored proce
dures etc ) and NOT on JOBs?
Thanx in advance,
GKramerHi,
You have to be member of SYSADMIN server role or member of DB_OWNER role
in MSDB database.
Thanks
Hari
MCDBA
"GKramer" <anonymous@.discussions.microsoft.com> wrote in message
news:92043A96-9386-486B-BC43-644C6EBB9CE6@.microsoft.com...
> Hi,
> I just wonder why I can grant / revoke on all objects ( tables, stored
procedures etc ) and NOT on JOBs?
> Thanx in advance,
> GKramer|||Jobs can only be viewed by a sysadmin or the job owner.
Rand
This posting is provided "as is" with no warranties and confers no rights.

No comments:

Post a Comment