Re: Can any please tell me how to make a user to see sql jobs.

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 09/04/05

  • Next message: Arpan: "Permissions!" 
    Date: Sat, 3 Sep 2005 22:02:30 -0600

    Hi,

    Setup a SQL Agent proxy account.

    >From books online:-

    When sp_help_job is invoked by a user who is a member of the sysadmin fixed
    server role, sp_help_job will be executed under the security context in
    which the SQL Server service is running. When the user is not a member of
    the sysadmin group, sp_help_job will impersonate the SQL Server Agent proxy
    account, which is specified using xp_sqlagent_proxy_account. If the proxy
    account is not available, sp_help_job will fail. This is true only for
    Microsoft® Windows NT® 4.0 and Windows 2000. On Windows 9.x, there is no
    impersonation and sp_help_job is always executed under the security context
    of the Windows 9.x user who started SQL Server.

    Thanks
    Hari
    SQL Server MVP

    "Raju" <npraju1@hotmail.com> wrote in message
    news:OSEJk0AsFHA.3720@TK2MSFTNGP14.phx.gbl...
    > Can any please tell me how to make a user to see sql jobs.
    > I know sys admins can see the jobs, but i want to give access to a user
    > who
    > is not sys admin.
    >
    > Thanks
    > Raju
    >
    >

  • Next message: Arpan: "Permissions!"

    Relevant Pages

    • Re: SQL account rights
      ... Please advice what is the best, suitable rights rather than domain admin ... issues, such as a server that might have IIS running on the same machine, ... applicable to SQL 2000 environment, ... files, or backups, make sure that the service account has Full ...
      (microsoft.public.sqlserver.security)
    • RE: MP Install issue
      ... Where in the installation are you talking about specifying the account rather ... > MPDB ERROR - CONNECTION PARAMETERS ... > SQL Server Name: servername ... > with a trusted SQL Server connection. ...
      (microsoft.public.sms.setup)
    • Re: SQL Express Fails with Hardware Error
      ... The LocalSystem account is a built-in account, ... which the SQL Service runs. ... MCSE, CCEA, Microsoft MVP - Terminal Server ... Minimum Hardware Requirement (Warning) ...
      (microsoft.public.sqlserver.setup)
    • Re: SCCM with a remote SQL instance problems (IT IS NOT A WARNING)
      ... PreReq check is not a WARNING it is a FAILURE. ... account the run the SQL Server Service on the server, Domain Memberships, AD ...
      (microsoft.public.sms.installer)
    • Re: Distributed Query - Linked Servers?
      ... In the case of SQL style accounts, it doesn't seem very secure to me, because the password will be transmitted over the network. ... it should also be able to work by setting up a credential and proxy account on Server1. ... In this case it could work with NTLM authentication. ... we just need to verify that the 2 sql server instances are under sql server and windows authentication mode and the sql account you use has the permission on the 2 sql server instances. ...
      (microsoft.public.sqlserver.server)