SQL Server contains two kinds of roles: standard roles and applicaton roles. Standard roles function like groups. For standard roles, users are assigned to the roles and then permissions are granted to those roles. Both types of roles can be created using the Enterprise Manager.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help