UFN_SYSTEMROLE_GETSYSTEMPRIVILEGELIST
Returns a table of IDs for all of System privileges that have been assigned to the given SYSTEMROLEID
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SYSTEMROLEID | uniqueidentifier | IN |
Definition
Copy
CREATE FUNCTION dbo.UFN_SYSTEMROLE_GETSYSTEMPRIVILEGELIST(@SYSTEMROLEID uniqueidentifier)
/*
Returns a table of IDs for all of the Reports that have been assigned to the given SYSTEMROLEID
*/
returns table
as
return
(
select SRP.ID, SRP.SYSTEMPRIVILEGECATALOGID,
SRP.GRANTORDENY
from
SYSTEMROLEPERM_SYSTEMPRIVILEGE as SRP
where SRP.SYSTEMROLEID=@SYSTEMROLEID
)