Show all Hide all

Returns all functions that a user belongs to.

Type: Table-valued function
Area of use: General use


@UserID mandatory int


Resultset: Functions

Repeat mode: repeated exactly once
Row count: zero or more rows


FunctionID mandatory int
Function ID
IsExplicit mandatory bit
If the user has been explicitly assigned the function, or only has inherited it from his role.