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