How to update user group as Service Account owner using custom query

[rahul_p]

Hello,

We want to update user group as owner of the Service Account using custom query through job.

Service Account will have already an owner initially which assigned during service account request but as we want to grant the modify and disable service account access to helpdesk, so we want to update the helpdesk user group as rank2 owner of all service account.

There is no specific key using which user group can be referred, so can anyone comment on this how to update the user group as owner of all service account.

Regards,

Rahul

[rushikeshvartak]

It will be inserted into accountowners table.

INSERT INTO accountowners (
ACCOUNTOWNERKEY,
ACCOUNTKEY,
OWNERUSERGROUPKEY,
RANK,
UPDATEDATE,
UPDATEUSER
) VALUES (
'1',
'100',
'200',
'2',
now(),
1
);

[rahul_p]

Hello @rushikeshvartak ,

So for user group :

INSERT INTO accountowners (
ACCOUNTOWNERKEY,
ACCOUNTKEY,
OWNERUSERGROUPKEY,
RANK,
UPDATEDATE,
UPDATEUSER
) VALUES (
'<null>',
'<serviceAccountKey>',
'<userGroupKey>',
'2',
now(),
1
);

Is this correct?

Thanks!

[rushikeshvartak · Accepted solution]

INSERT INTO accountowners (
ACCOUNTKEY,
OWNERUSERGROUPKEY,
RANK,
UPDATEDATE,
UPDATEUSER
) VALUES (
'<serviceAccountKey>',
'<userGroupKey>',
'2',
now(),
1
);