Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Execute permission Expand / Collapse
Author
Message
Posted Wednesday, July 23, 2014 7:50 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 6:27 AM
Points: 261, Visits: 865
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
Post #1595488
Posted Wednesday, July 23, 2014 8:31 AM This worked for the OP Answer marked as solution
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 8:14 AM
Points: 71, Visits: 220
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.
Post #1595510
Posted Wednesday, July 23, 2014 8:36 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 6:27 AM
Points: 261, Visits: 865
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.
Post #1595511
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse