11-25-2022 12:09 AM
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 )
FROM Users Where EMPLOYEETYPE = 'External' AND SYSTEMUSERNAME = TH14000233
Can Team help me with this
NOTE-Currently, I can't use Technical Rules and Actionable Analytics due to some issue with DB'S Endpoint entitlement value import.
Solved! Go to Solution.
11-25-2022 12:26 AM
could you please refer the below post
11-25-2022 03:10 AM
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
11-25-2022 04:17 AM
Data analyzer does not list all tables
INSERT INTO user_savroles (USERKEY,ROLEKEY )
FROM Users Where EMPLOYEETYPE = 'External' AND SYSTEMUSERNAME = 'TH14000233'