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

Alter logins rights to user/Login Expand / Collapse
Author
Message
Posted Friday, May 2, 2014 11:24 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, June 26, 2014 1:18 AM
Points: 90, Visits: 135

Hi i want to provide create and alter login rights to user where he can change password of logins.Apart of securityadmin rights what can be done.
I mean user with securityadmin rights cannot create/alter password of logins with sysadmin rights
Post #1567133
Posted Monday, May 5, 2014 1:31 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 2:44 AM
Points: 5,018, Visits: 10,532
You need to grant ALTER ANY LOGIN to do that, which is the axact same permission granted to securityadmin.
In other words, you can't do that directly.
You should grant ALTER LOGIN permissions on the individual logins instead.


--
Gianluca Sartori

Get your two-cent-answer quickly
spaghettidba.com
@spaghettidba
Post #1567426
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse