USP_IDSET_GRANTRIGHTSTOFUNCTION
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @IDSETFUNCTIONNAME | nvarchar(128) | IN | |
| @GRANTTYPE | nvarchar(32) | IN |
Definition
Copy
CREATE procedure [dbo].[USP_IDSET_GRANTRIGHTSTOFUNCTION](@IDSETFUNCTIONNAME nvarchar(128), @GRANTTYPE nvarchar(32))
with execute as owner
as
exec ('grant ' + @GRANTTYPE + ' on [' + @IDSETFUNCTIONNAME + '] to BBAPPFXSERVICEROLE');
exec ('grant ' + @GRANTTYPE + ' on [' + @IDSETFUNCTIONNAME + '] to BBAPPFXREPORTROLE');