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.