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?