GrantPrincipalPermission Procedure (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.]
Grants a principal permission to perform an operation on a resource.
[Repository.Item].[GrantPrincipalPermission] ( @principal, @resourceKind, @resource, @operation, @mayGrantOrRevoke )
Arguments
@principal
Type: sysname. The principal name.
@resourceKind
Type: [Repository.Item].[SecuredResourceKindId]. The identifier of the resource kind.
@resource
Type: [Repository.Item].[SecuredResource]. The secured resource.
@operation
Type: [Repository.Item].[SecuredOperationId]. The operation permitted on the resource.
@mayGrantOrRevoke
Type: bit. A bit flag that indicates whether the current user is allowed to grant or revoke this resource operation to other principals.