Grants permissions on a table, view, table-valued function, stored procedure, extended stored procedure, scalar function, aggregate function, service queue, or synonym.

GRANT REFERENCES, EXECUTE ON TYPE :: dbo.DatabaseType TO Role01

Syntax

GRANT <permission> [ ,...n ] ON   
    [ OBJECT :: ][ schema_name ]. object_name [ ( column [ ,...n ] ) ]  
    TO <database_principal> [ ,...n ]   
    [ WITH GRANT OPTION ]  
    [ AS <database_principal> ]  
  
<permission> ::=  
    ALL [ PRIVILEGES ] | permission [ ( column [ ,...n ] ) ]  
  
<database_principal> ::=   
        Database_user   
    | Database_role   
    | 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   
    | Database_user_with_no_login  
Object permissionImplied by object permissionImplied by schema permission
ALTERCONTROLALTER
CONTROLCONTROLCONTROL
DELETECONTROLDELETE
EXECUTECONTROLEXECUTE
INSERTCONTROLINSERT
RECEIVECONTROLCONTROL
REFERENCESCONTROLREFERENCES
SELECTRECEIVESELECT
TAKE OWNERSHIPCONTROLCONTROL
UPDATECONTROLUPDATE
VIEW CHANGE TRACKINGCONTROLVIEW CHANGE TRACKING
VIEW DEFINITIONCONTROLVIEW DEFINITION
Last modified: August 1, 2019

Author

Comments

Write a Reply or Comment