USP_DATAFORMTEMPLATE_EDIT_ADHOCQUERY_PERMISSIONS

Updates a ad-hoc query instance's permissions.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@SECURITYLEVEL	tinyint	IN	Security level
@SYSTEMROLELIST	xml	IN	System Role List

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_ADHOCQUERY_PERMISSIONS
            (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,    
                @SECURITYLEVEL tinyint,
                @SYSTEMROLELIST xml

            ) AS
                set nocount on;

                declare @SECURITYLEVELEDIT tinyint, @SYSTEMROLELISTEDIT xml

                exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_ADHOCQUERYINSTANCE_PERMISSIONS    @ID = @ID, 
                                                                                        @SECURITYLEVELEDIT = @SECURITYLEVELEDIT output,
                                                                                        @SYSTEMROLELISTEDIT = @SYSTEMROLELISTEDIT output

                exec dbo.USP_DATAFORMTEMPLATE_EDIT_ADHOCQUERY_PERMISSIONS_2        @ID, 
                                                                                @CHANGEAGENTID, 
                                                                                @SECURITYLEVEL, 
                                                                                @SYSTEMROLELIST,
                                                                                @SECURITYLEVELEDIT,
                                                                                @SYSTEMROLELISTEDIT