This topic has not yet been rated - Rate this topic

GRANT Database Permissions (Windows Azure SQL Database)

Grants permissions on a database.

Syntax Conventions (Windows Azure SQL Database)


GRANT <permission> [ ,...n ]  
    TO <database_principal> [ ,...n ] [ WITH GRANT OPTION ]
    [ AS <database_principal> ]

<permission>::=  permission | ALL [ PRIVILEGES ]

<database_principal> ::= Database_user 
    | Database_role 
    | Database_user_with_no_login

Arguments

This syntax diagram demonstrates the supported arguments and options in Microsoft Windows Azure SQL Database.

Windows Azure SQL Database does not support the following options with this GRANT statement:

<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

For more information about the arguments and this GRANT statement, see GRANT Database Permissions in SQL Server Books Online.

Concepts

Partially Supported Transact-SQL Statements (Windows Azure SQL Database)
Transact-SQL Reference (Windows Azure SQL Database)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD