Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "what is the role of SQL fixed database". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Database roles grant different levels of permissions to manage or access databases and database objects to a user or a group of users, which are database-specific and enable a user to have multiple roles belonging to the same database. SQLServer provides two types of database roles: system fixed roles and user-defined roles.

SQL fixed database role

SQL fixed database role means that SQLServer has defined the permissions of these roles to manage and access the database, and SQLServer managers cannot make any changes to their permissions. Each database in SQLServer has a set of fixed database roles. Using SQL fixed database roles in the database can assign different levels of database management to different roles, thus effectively realizing the transfer of work permissions. SQLServer provides ten commonly used fixed database roles to grant combined database-level administrator privileges, and these SQL fixed database role information is stored in the system table sysusers. Its meaning is as follows:

What is the SQL fixed database role

Public:

Db_owner: have full permissions in the database.

Db_accessadmin: you can add or remove user ID.

Db_ddladmin: ownership of the ALLDDL operation can be issued.

Db_securityadmin: you can manage all permissions, object ownership, roles, and role membership.

Db_backupoperator: you can issue DBCC, CHECKPOINT, and BACKUP statements.

Db_datareader: you can select all the data in any user table in the database.

Db_datawriter: you can change all data in any user table in the database.

Db_denydatareader: you cannot select any data in any user table in the database.

Db_denydatawriter: you cannot change any data in any user table in the database.

In a fixed database role, public is a special database role, and each user in the database is a member. Users, groups, or other roles cannot be assigned to the public role, the public role is included in every database, and the role cannot be deleted.

This is the end of the content of "what does the SQL fixed database role mean?" Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.