The most specific and limited permissions that can be granted on a database are listed in the following table, together with the more general permissions that include them by implication. In this case, the user must also have SELECT permission on the computed column.Ī database is a securable contained by the server that is its parent in the permissions hierarchy. For example: A user with ALTER permission on a table and REFERENCE permission on a function can create a computed column over a function and have it be executed. RemarksĪ combination of ALTER and REFERENCE permissions in some cases could allow the grantee to view data or execute unauthorized functions. Specifies a database user with no corresponding server-level principal. Specifies a database user mapped to an asymmetric key. Specifies a database user mapped to a certificate.ĭatabase_user_mapped_to_asymmetric_key Applies to: SQL Server 2008 (10.0.x) and later Specifies a database user mapped to a Windows group.ĭatabase_user_mapped_to_certificate Applies to: SQL Server 2008 (10.0.x) and later ![]() Specifies a database user mapped to a Windows user.ĭatabase_user_mapped_to_Windows_Group Applies to: SQL Server 2008 (10.0.x) and later Specifies a principal from which the principal executing this query derives its right to grant the permission.Īpplication_role Applies to: SQL Server 2008 (10.0.x) and later, SQL Databaseĭatabase_user_mapped_to_Windows_User Applies to: SQL Server 2008 (10.0.x) and later Indicates that the principal will also be given the ability to grant the specified permission to other principals. ![]() ![]() Granting ALL is equivalent to granting the following permissions: BACKUP DATABASE, BACKUP LOG, CREATE DEFAULT, CREATE FUNCTION, CREATE PROCEDURE, CREATE RULE, CREATE TABLE, and CREATE VIEW. This option does not grant all possible permissions. For a list of the permissions, see the Remarks section later in this topic. Specifies a permission that can be granted on a database. To view Transact-SQL syntax for SQL Server 2014 and earlier, see Previous versions documentation.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |