Post reply

xp_sqlagent_proxy_account

  • August 13, 2002 at 2:39 pm

    #64185

    What are the cons of setting this in SQL2000? Are there any security "gotchas" that I am not thinking of?

    Thanks in advance.

    To give real service you must add something that cannot be bought or measured with money, and that is sincerity and integrity.


    Be great!
    Michael

  • August 13, 2002 at 3:14 pm

    #434509

    Keep in mind that non-sysadmin jobs and uses of xp_cmdshell will be under the user account set in xp_sqlagent_proxy_account. Therefore, execution will be under that user's context. If the account is a local administrator on the box, they will have that level of access.

    K. Brian Kelley

    bkelley@sqlservercentral.com

    http://www.truthsolutions.com/

    K. Brian Kelley
    @kbriankelley

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply