|MS SQL Server 2012 - DBA Articles|
SQL Server - Database Level Fixed Roles
To easily manage the permissions in your databases, SQL Server provides several roles which are security principals that group other principals. They are like groups in the Microsoft Windows operating system. Database-level roles are database-wide in their permissions scope.
There are two types of database-level roles in SQL Server: fixed database roles that are predefined in the database and flexible database roles that you can create.
Fixed database roles are defined at the database level and exist in each database. Members of the db_owner and db_securityadmin database roles can manage fixed database role membership. However, only members of the db_owner database role can add members to the db_owner fixed database role. There are also some special-purpose fixed database roles in the msdb database.
The following table shows the fixed database-level roles and their capabilities. These roles exist in all databases.
public Database Role
Every database user belongs to the public database role. When a user has not been granted or denied specific permissions on a securable object, the user inherits the permissions granted to public on that object.
More Reference URL: http://msdn.microsoft.com/en-us/library/ms189121%28v=sql.110%29.aspx
* * * * *