SessionsPermissions View (Repository.Item Schema)
[This content is no longer valid. For the latest information on "M", "Quadrant", SQL Server Modeling Services, and the Repository, see the Model Citizen blog.]
Returns a list of permitted resource operations for the current database session.
Fields
The following table lists the fields in the SessionsPermissions view.
| Column | Type | Required | Description |
|---|---|---|---|
ResourceKind |
uniqueidentifier |
yes |
The identifier of the resource kind. |
Resource |
sql_variant |
The secured resource. |
|
Operation |
uniqueidentifier |
yes |
The identifier of the permitted operation on the resource. |
MayGrantOrRevoke |
bit |
yes |
A bit flag that indicates whether the current user is allowed to grant or revoke this permission to other principals. |