User Defined Server Roles provide companies with a fine grained permission control at a server level rather than at a database level. This will help to maintain consisten application of security policies acrodd all databases on a server.
XTIVIA can help you implement User Defined Server Roles. We can help you with creation of these roles and setting permissions.
Previously Server roles were fixed and no additions could be made. With this change a Server role may be created that will apply to all databases on the server. This will substantially simplify management where users need to access multiple databases with the same capabilities.
« Return to Microsoft SQL Server 2012 Features & Enhancements