cancel
Showing results for 
Search instead for 
Did you mean: 

ADD BULK User to the SAV Role-"CUSTOMQUERYJOB"

Puspanjali
New Contributor
New Contributor

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.

3 REPLIES 3

Srinivas
Saviynt Employee
Saviynt Employee

Hi Srinivas

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

Puspanjali_0-1669373672193.png

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'

Puspanjali_3-1669374276570.png

Puspanjali_1-1669374186956.pngPuspanjali_2-1669374208666.png

Our Current version is-v5.5SP3.12.14

Data analyzer does not list all tables

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