Fixed Roles

In Microsoft SQL Server, database roles are used to group and manage sets of database-level permissions. These roles help simplify the management of user access and permissions within a database. There are several predefined database roles available in SQL Server.

Here are some of the key database roles in SQL Server:

1. db_owner: This role has the highest level of permissions within a database. Members of this role can perform all configuration and maintenance tasks, including creating and modifying objects, granting permissions, and managing database settings. By default, the user who creates the database becomes a member of this role.
2. db_datareader: Members of this role have read access to all user tables in the database. They can execute SELECT statements and view data, but they cannot modify or delete data.
3. db_datawriter: Members of this role have write access to all user tables in the database. They can perform INSERT, UPDATE, and DELETE operations on the data but cannot read the data using SELECT statements.
4. db_executor: This role allows members to execute stored procedures, user-defined functions, and extended stored procedures in the database. They can run existing code but cannot modify or create new objects.
5. db_ddladmin: Members of this role have permission to create, modify, and delete any objects within the database. They can perform Data Definition Language (DDL) operations, such as creating tables, views, and stored procedures.
6. db_securityadmin: This role allows members to manage database-level security. They can grant, revoke, and deny permissions on various database objects. Members of this role can also reset passwords and manage roles.
7. db_backupoperator: Members of this role can back up the database. They can perform tasks related to backup and restore operations but do not have access to the actual data.
8. db_denydatareader and db_denydatawriter: These roles explicitly deny read and write access to all user tables, respectively. Members of these roles cannot perform any read or write operations on the data.

In the Nebula Framework, the Fixed Roles page allows an administrator to assign users to appropriate roles to manage security, enforce separation of duties, and control access to the database objects and data.

The page contains two grids: Roles (top) and Members (bottom).