DB - Grant Access
Last updated
Last updated
Um login pode ter associado um único user em cada DB cujo nome pode ser distinto entre DBs.
Can authorize a user to access the database, but not manage database-level security
Can perform backups, checkpoints, and DBCC commands, but not restores (only server sysadmins can)
Can read all the data in the database. This role is the equivalent of a grant on all objects, and it can be overridden by a deny permission.
Can write to all the data in the database. This role is the equivalent of a grant on all objects, and it can be overridden by a deny permission.
Can issue DDL commands (create, alter, drop)
Can read from any table in the database. This deny will override any object-level grant.
Blocks modifying data in any table in the database. This deny will override any object-level grant.
A special role that has all permissions in the database. This role includes all the capabilities of the other roles. It is different from the dbo user role. This is not the database-level equivalent of the server sysadmin role; an object-level deny will override membership in this role.
Can manage database-level security — roles and permissions