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

User Defined Server Roles in SQL2012 Expand / Collapse
Author
Message
Posted Friday, July 5, 2013 12:51 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 22, 2014 12:45 PM
Points: 161, Visits: 665
When using UD Server Roles do you still have to map logins to db's at the "Security>Login level"?

Was hoping to just add logins to the server role without mapping db users to each login.



Post #1470838
Posted Monday, July 8, 2013 1:46 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, August 7, 2014 2:08 AM
Points: 4,432, Visits: 4,171
Yes, you still have to give DB access to the logins.
User-defined server roles simply offer you a more granular option to defeine server permissions,but you still have to set database access and permissions.


Markus Bohse
Post #1471066
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse