and more in a single search tool across platforms. Read the announcement here. |
12/28/2023 06:22 AM
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
Solved! Go to Solution.
12/28/2023 08:27 AM
It will be inserted into accountowners table.
INSERT INTO accountowners (
ACCOUNTOWNERKEY,
ACCOUNTKEY,
OWNERUSERGROUPKEY,
RANK,
UPDATEDATE,
UPDATEUSER
) VALUES (
'1',
'100',
'200',
'2',
now(),
1
);
12/28/2023 11:58 PM
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!
12/29/2023 12:49 AM
INSERT INTO accountowners (
ACCOUNTKEY,
OWNERUSERGROUPKEY,
RANK,
UPDATEDATE,
UPDATEUSER
) VALUES (
'<serviceAccountKey>',
'<userGroupKey>',
'2',
now(),
1
);