If a SQL Server instance contains 100 SQL Server Logins (not the windows\domain logins).
I want to grant read access to 50 SQL logins and read\write to other 50 logins.
If we have capability to create SQL Groups at SQL instance level, I can add 50 logins to that SQL Group and grant permissions at group level.
In SQL Server 2012 version we can create SQL Server roles. This might help little bit in these scenarios but still want to know if we can get the facility to create the SQL Groups at Instance level.
Please let me know if we have any options available like this in SQL Server 2008 R2 and upcoming versions.