This topic has not yet been rated - Rate this topic

DENY Type Permissions (SQL Azure Database)

Denies permissions on a type.

Copy


DENY permission  [ ,...n ] ON TYPE :: [ schema_name . ] type_name
        TO <database_principal> [ ,...n ]
    [ CASCADE ]
    [ AS <database_principal> ]

<database_principal> ::= Database_user 
    | Database_role 
    | Database_user_with_no_login

Arguments

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

SQL Azure Database does not support the following options with this DENY 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 DENY statement, see DENY Type Permissions (Transact-SQL) in SQL Server Books Online.

Concepts

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

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)