GRANT Database Principal Permissions (Windows Azure SQL Database)
Grants permissions on a database user, database role, or application role.
Syntax Conventions (Windows Azure SQL Database)
GRANT permission [ ,...n ]
ON
{ [ USER ::database_user ]
| [ ROLE ::database_role ]
}
TO <database_principal> [ ,...n ]
[ WITH GRANT OPTION ]
[ AS <database_principal> ]
<database_principal> ::=Database_user
| Database_role
| Database_user_with_no_login
This syntax diagram demonstrates the supported arguments and options in Microsoft Windows Azure SQL Database.
Windows Azure SQL Database does not support the following arguments and options when using this GRANT statement:
-
GRANT ON APPLICATION ROLE
-
<database_principal> options:
-
Application_role
-
Database_user_mapped_to_Windows_User
-
Database_user_mapped_to_Windows_Group
-
Database_user_mapped_to_certificate
-
Database_user_mapped_to_asymmetric_key
-
Application_role
For more information about the arguments and this GRANT statement, see GRANT Database Principal Permissions in SQL Server Books Online.
