| GRANT permission [ ,...n ] ON
|
Specifies a permission that can be granted on an XML schema collection.
|
| XML SCHEMA COLLECTION :: [ schema_name . ] |
Specifies the XML schema collection on which the permission is being granted.
|
| XML_schema_collection_name |
|
| TO <database_principal> [ ,...n ] |
Specifies the principal to which the permission is being granted. |
| [ WITH GRANT OPTION ] |
Indicates that the principal will also be given the ability to grant the
specified permission to other principals. |
| [ AS <database_principal> ]
|
Specifies a principal from which the principal executing this query derives its
right to grant the permission. |
| <database_principal> ::=
|
|
| Database_user
|
Specifies a database user. |
| | Database_role
|
Specifies a database role. |
| | Application_role |
Specifies an application role. |
| | Database_user_mapped_to_Windows_User
|
Specifies a database user mapped to a Windows user. |
| | Database_user_mapped_to_Windows_Group
|
Specifies a database user mapped to a Windows group. |
| | Database_user_mapped_to_certificate
|
Specifies a database user mapped to a certificate. |
| | Database_user_mapped_to_asymmetric_key
|
Specifies a database user mapped to an asymmetric key. |
| | Database_user_with_no_login |
Specifies a database user with no corresponding server-level principal. |
|
|
