USP_RECORDOPERATION_APPUSERENABLERUNAS
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@ID | uniqueidentifier | IN | |
@CHANGEAGENTID | uniqueidentifier | IN |
Definition
Copy
create procedure dbo.USP_RECORDOPERATION_APPUSERENABLERUNAS
(
@ID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier = null
)
as
set nocount on;
if @CHANGEAGENTID is null
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;
update
dbo.APPUSER
set
HASRUNASRIGHTS = 1,
CHANGEDBYID = @CHANGEAGENTID,
DATECHANGED = getdate()
where
APPUSER.ID = @ID;
return 0;