Export (0) Print
Expand All

REVOKE Type Permissions (Azure SQL Database)

This topic is OBSOLETE. You can find the most current version in the SQL 14 Transact-SQL Reference.

ImportantImportant
This topic is not maintained. For the current version, see REVOKE Type Permissions (Transact-SQL).

Revokes permissions on a type.

Syntax Conventions (Azure SQL Database)


REVOKE [ GRANT OPTION FOR ] permission [ ,...n ] 
    ON TYPE :: [ schema_name ].type_name 
        { FROM | TO } <database_principal> [ ,...n ] 
    [ CASCADE ]
    [ 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 Microsoft Azure SQL Database.

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

Community Additions

ADD
Show:
© 2014 Microsoft