Re: permissions to view jobs but not change them

From: J Jetson (JJetson_at_discussions.microsoft.com)
Date: 09/24/04


Date: Fri, 24 Sep 2004 08:03:02 -0700

Sorry, I meant view jobs... in the Jobs viewer in Enterprise Manager. Is
there a combination of permissions or a role that would let a user view a job
and check its success without being able to modify it in any way. Thanks.

"Tibor Karaszi" wrote:

> What do you exactly mean by "view stored procedures"? Look at the source code? Everyone can do that
> unless you have encrypted the procedure (then no-one can do that).
>
> Also, what do you mean by "and their success"?
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
>
> "J Jetson" <JJetson@discussions.microsoft.com> wrote in message
> news:7D66188B-9C98-42B3-8989-8CC23E7C97DC@microsoft.com...
> > is there any combination of permissions or a role that will let a user view
> > stored procedures and their success without being able to modify them? Thanks.
>
>
>



Relevant Pages

  • Re: SQL 2000 view current job status best practice
    ... Then what you could do is grant permissions to execute the procedure to the ... jobs running on production SQL 2000 Servers. ... group has very limited access to these production servers - such that they ... allow the support personnel to view the status of jobs ...
    (microsoft.public.sqlserver.security)
  • 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)
  • Sqlagentuserrole
    ... I have a multi-part question regarding giving permissions to manage sql agent ... permissions to the necessary databases against which jobs will run, ... sysadmin to write to the output file. ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 2000 view current job status best practice
    ... Then what you could do is grant permissions to execute the procedure to the ... Warren Brunk - MCITP - SQL 2005, ... jobs running on production SQL 2000 Servers. ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server JOBS
    ... Are you trying to create jobs using DDL? ... stored procedures to both create and query jobs. ... The same is for Alerts. ... > I am developing a windows application where i need to give users alerts ...
    (microsoft.public.dotnet.framework.adonet)