PermissionTargetType Enumeration

The PermissionTargetType enumeration provides a list of recognized server targets that can be assigned permissions.

Enumeration Values

Name	Summary
Select	Specifies that the principal will be able to select or read values from the target object.
Update	Specifies that the principal will be able to update values in the target object.
References	Specifies that the principal will have the reference privelege for the target object.
Insert	Specifies that the principal will be able to insert new values into the target object.
Delete	Specifies that the principal will be able to delete values from the target object.
Alter	Specifies that the principal will be able to modify the schema or other metadata associated with the target object.
ViewChangeTracking	Specifies that the principal will be view change tracking informationable to delete values from the target object.
ViewDefinition	Specifies that the principal will be able to view schema or other metadata information associated with the target object.
TakeOwnership	Specifies that the principal will be able to take ownership of the target object.
Control	Specifies that the principal will have control priveleges for the target object.
Execute	Specifies that the principal will be able to execute the target object.
All	Specifies the ALL permission. This is equivalent to the ANSI SQL92 ALL Permission, which has different behaviors depending on the target object.