Post reply

Execute permission

  • July 23, 2014 at 7:50 am

    #293689

    Hello,

    I am trying to execute xp_logininfo.

    Part of the KB says: "membership in the public fixed database role in the master database with EXECUTE permission granted". I understand how to set the public role which is on by default when I map the database.

    However, how do I set EXECUTE permission? Is this on the database or just the sp?

    Thanks

    djj

  • July 23, 2014 at 8:31 am

    #1731772

    Hi,

    Yes you need to grant permissions to the proc. Such as this:

    GRANT EXECUTE on xp_logininfo to [Database_User]

    Depending on how you feel about assigning permissions for users directly against objects, you could also create a role then add the relevant user account to this and grant the role EXECUTE permissions.

  • July 23, 2014 at 8:36 am

    #1731773

    simon.guerin 52106 (7/23/2014)

    Hi,

    Yes you need to grant permissions to the proc. Such as this:

    GRANT EXECUTE on xp_logininfo to [Database_User]

    Depending on how you feel about assigning permissions for users directly against objects, you could also create a role then add the relevant user account to this and grant the role EXECUTE permissions.

    Thanks simon.guerin.

    I get vary confused every time I try and understand Microsoft's security instructions.

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

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