USP_RE7SYSTEMROLE_SETQUERYVIEWPERMISSIONS

Parameters

Parameter	Parameter Type	Mode
@NEWFEATUREID	uniqueidentifier	IN
@PERMISSIONEDFEATUREID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure [dbo].[USP_RE7SYSTEMROLE_SETQUERYVIEWPERMISSIONS]
            (
                @NEWFEATUREID uniqueidentifier,
                @PERMISSIONEDFEATUREID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier
            )
            as

            set nocount on;

            begin try

                if @CHANGEAGENTID is null
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

        exec dbo.USP_SYSTEMROLE_COPYQUERYVIEWPERMISSIONS @NEWFEATUREID, @PERMISSIONEDFEATUREID, @CHANGEAGENTID;

            end try

            begin catch
                exec dbo.USP_RAISE_ERROR;
            end catch

            return 0;