I am able to run the query below successfully to kick off the ADS_ADSAccount_Update/(De-)activate process orchestration with my ID from both SQL management studio and Object Brower. However, I am not able to run successfully with a service account. Is there a persmission that needs to be granted for this to work with a service account and if so where? The UID_Person and UID_TSBAccountDef below are redacted.
Declare @procid varchar(38)
select @procid= newid()
Declare @objkeys dbo.QBM_YParameterList
-- Update
exec dbo.QBM_PJobCreate_HOUpdate
'ADSAccount','UID_Person= ''000000000-0000-0000-0000-0000-0000000000''
AND UID_TSBAccountDef = ''000000000-0000-0000-0000-0000-0000000000'''
AND isGroupAccount = 0'
,@GenProcID=@procid,@ObjectKeysAffected=@objkeys,
@p1='extensionattribute11',@v1='Firsttest',
@p2='XTouched',@v2='U'