Mary could revoke the permission using the AS RAUL clause to remove Raul's grant of the permission. The sys.database_permissions table will indicate the permissions twice but they will each have a different grantor_principal_id value. Both Mary and Raul grant a user named Steven the same permission. For example, presume that user Mary is principal_id 12 and user Raul is principal_id 15. Use the AS principal clause to indicate that you are revoking a permission that was granted by a principal other than you. When you are using the CASCADE argument, you must also include the GRANT OPTION FOR argument.Ī cascaded revocation of a permission granted WITH GRANT OPTION will revoke both GRANT and DENY of that permission. Indicates that the permission that is being revoked is also revoked from other principals to which it has been granted by this principal. For more information about valid combinations, see the topics listed in Securable-specific Syntax later in this topic. The principals from which permissions on a securable can be revoked vary, depending on the securable. Specifies the securable on which the permission is being revoked.
Specifies the class of the securable on which the permission is being revoked. Specifies the name of a column in a table on which permissions are being revoked.
The valid mappings of permissions to securables are described in the topics listed in Securable-specific Syntax later in this topic. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
This feature will be removed in a future version of Microsoft SQL Server.
0 kommentar(er)
