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


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 1:56 PM
Points: 322, Visits: 1,007
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
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 7:29 AM
Points: 92, Visits: 249
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


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 1:56 PM
Points: 322, Visits: 1,007
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