USP_BUSINESSPROCESS_CREATETVF
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @FUNCTIONNAME | nvarchar(128) | IN | |
| @CREATESQL | nvarchar(max) | IN |
Definition
Copy
create procedure dbo.[USP_BUSINESSPROCESS_CREATETVF]
(
@FUNCTIONNAME nvarchar(128),
@CREATESQL nvarchar(max)
)
with execute as owner
as
declare @SQL nvarchar(max);
set nocount on;
exec (@CREATESQL);
set @SQL = 'grant select on dbo.[' + @FUNCTIONNAME + '] to [BBAPPFXSERVICEROLE]';
exec (@SQL);
return 0;