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.