ADD BULK User to the SAV Role-"CUSTOMQUERYJOB"

[Puspanjali]

Hi Team

My requirement is to add around 500 External users to one SAV role"ROLE_MANAGER"

As I understood from a few posts that from UI we can't directly import CSV to add a user to the SAV role

But we can use CUSTOMQUERYJOB to add a user to the SAV Role

This query I'm using for a single user, but it is failing

INSERT INTO user_savroles (USERKEY,ROLEKEY,UPDATEDATE,UPDATEUSER )
SELECT USERKEY,15,CURDATE(),10240
FROM Users Where EMPLOYEETYPE = 'External' AND SYSTEMUSERNAME = TH14000233

Can Team help me with this

Reference- https://forums.saviynt.com/t5/general-discussions/populating-sav-roles/m-p/2168

NOTE-Currently, I can't use Technical Rules and Actionable Analytics due to some issue with DB'S Endpoint entitlement value import.

[Srinivas]

Hello @Puspanjali

could you please refer the below post

https://forums.saviynt.com/t5/identity-governance/how-to-assign-a-sav-role-to-a-large-number-of-user...

Regards

Srinivas

[Puspanjali]

Hi Srinivas

Actually, I went through that article first, But if see the table

The requester has used the table called "savroles" to get the rolekey, But I'm not sure if it is a version issue or not this table is not present in our Schema Table list we have only these 2 tables 'user_savroles' and 'dashboard_savroles'

Our Current version is-v5.5SP3.12.14

[rushikeshvartak · Accepted solution]

Data analyzer does not list all tables

INSERT INTO user_savroles (USERKEY,ROLEKEY )
SELECT USERKEY,15
FROM Users Where EMPLOYEETYPE = 'External' AND SYSTEMUSERNAME = 'TH14000233'

[haardik_verma]

Hi @rushikeshvartak , will the same work for bulk adding users in Saviynt UserGroup?

Please check this How to bulk add users in UserGroup based on a cond... - Saviynt Forums - 28764