Execute permission

  • 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

  • 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.

  • 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