CurrentPermissions 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 permissions for the current database session. This list includes resources and the operations that are allowed on those resources.
Fields
The following table lists the fields in the CurrentPermissions view.
| Column | Type | Required | Description |
|---|---|---|---|
ResourceKind |
uniqueidentifier |
yes |
The resource kind. |
ResourceKindDescription |
nvarchar(max) |
The description of the resource kind (typically available in several languages). |
|
Resource |
sql_variant |
The secured resource. |
|
Operation |
uniqueidentifier |
yes |
The permitted operation on the resource. |
OperationDescription |
nvarchar(max) |
The description of the permitted operation on the resource (typically available in several languages). |
|
MayGrantOrRevoke |
bit |
A bit flag that indicates whether the current user is allowed to grant or revoke this resource operation to other principals. |