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

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 02/27/04 

Date: Fri, 27 Feb 2004 15:43:09 +0530

Hi,

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

Relevant Pages

  • Re: Giving access to manage sql jobs
    ... Do you want the user to be able to modify only his/her jobs or all people? ... He/She mus be a member of sysadmin server role otherwise you are going to ... > What permissions, and how, can I give them permissions without making them ...
    (microsoft.public.sqlserver.security)
  • Re: Problems creating subscription...
    ... The distribution agent job has been implicitly created and ... 'ROUSES.COM\LarryDSI' is a member of sysadmin server role and cannot be ... granted to or revoked from the proxy. ...
    (microsoft.public.sqlserver.replication)
  • Re: how could i hide my finacial data to sa when i store them in sql server 2k?
    ... Where does the info reside? ... You can adde the user to db_denydatareader role and make sure that he/she is ... not a member of sysadmin server role. ...
    (microsoft.public.sqlserver.security)
  • Re: Executing Jobs via a SQL Statement
    ... Note that you still need to be the owner of a job or a member of the ... sysadmin server role to start jobs with sp_start_job, ... SQL Server MVP ...
    (microsoft.public.sqlserver.dts)
  • Re: Basic Server Roles (security) question
    ... Are you member of sysadmin server role as well? ... > I want to add a consulting firm of ours to have full access to a ... > nothing I can find talks about this kind of granularity in security. ...
    (microsoft.public.sqlserver.security)