Post reply

xp_cmdshell not working for users

  • May 4, 2016 at 12:43 pm

    #400112

    We have a SQL cluster set up and when the users/programs access the server there is a public login set up...pvtreader.

    When I log onto the primary or the secondary it shows the user pvtreader was granted access to use xp_cmdshell.

    but when I log into the cluster as pvtreader, I cannot execute xp_cmdshell. I get the below error message.

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

    the xp_cmdshell proxy has been setup and when I look at security for the master database it show that pvtreader has the securable set for xp_cmdshell

  • May 4, 2016 at 1:23 pm

    #1876718

    carol can you simpyl test your users xp_cmdshell permissions? does this still give permissions errors?

    EXECUTE AS USER='pvtreader' --test as our specific users permissions.

    exec xp_cmdshell 'whoami'

    REVERT; --change back into myself

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • May 4, 2016 at 1:57 pm

    #1876722

    Yes it gives the error that I show in my original message.

    This used to work, but something happened and now it doesn't.

  • May 6, 2016 at 6:42 am

    #1877105

    I got this to work be deleting the login under the MASTER database and re-adding making sure to add his schema

  • June 15, 2016 at 10:17 am

    #1885199

    Carol Adams (5/6/2016)

    I got this to work be deleting the login under the MASTER database and re-adding making sure to add his schema

    I have a question.

    Was this cluster setup and then the databases migrated from another server?

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

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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy