Post reply

problem with xp_cmdshell

  • July 15, 2009 at 4:37 am

    #208188

    Hi ,

    I have created a SQl authenticated login ,and given db_owner rights to that login ,however not able to execute the SP which is having xp_cmdshell,

    following are the message i am getting

    The EXECUTE permission was denied on the object 'xp_cmdshell', database 'mssqlsystemresource', schema 'sys'.

    please help me

  • July 15, 2009 at 5:29 am

    #1024928

    the user needs execute permissions on the extended stored proceedure which is in the master database.

  • July 15, 2009 at 6:30 am

    #1024961

    sorry,didnt get you .

    my login name is tech12

    how do we give access

  • July 15, 2009 at 6:32 am

    #1024965

    USE [Master]

    GO

    CREATE USER [tech12] FOR LOGIN [Tech12]

    GO

    grant execute on xp_cmdshell to tech12

    go

  • July 15, 2009 at 6:48 am

    #1024982

    thank you,it worked

Viewing 5 posts - 1 through 4 (of 4 total)

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