How to assign multiple entitlements/insert multiple records for a single user in DB for a JDBC connector identitynow?

Identity Security Cloud (ISC) ISC Discussion and Questions
, ,
21

I think you are not making RColumn as entitlement. It looks like you have two entitlement types. Or you can do this create a combination of Role and RColumn in SailPoint as entitlment. When Role & RColumn is requested in SailPoint you will get them as each request. When multiple are requested you will get multiple request. Now in the rule you can apply a logic to split Role and RColumn in your rule to add each role but a different RColumn for the same user in the table.

22

Hi @udayputta , When I make 2 columns as entitlement and run entitlement aggregation, I think its duplicating entitlements and somehow I thought it is all messed up. But can you please share me some steps to setup multiple entitlements in the source correctly? And how should I set up in entitlement types section in connector if we are having 2 entitlements. Also, Can you please share the connector rule logic to achieve this?

23

Hi Everyone ,

I have set only RColumn as entitlement in my source.When I raise request for second time with same Role and different RColumn value for same user, this request is going to Modify operation and I’m getting values for only userId and Role, rest other column values are retrieved as null. Is this because it is a modify operation and I’m not supposed to see other values? If I’m able to figure out this I think I should be able to insert second request record in DB. Any suggestions??

@udayputta @officialamitguptaa @vijayasaikoppineni @Abhishek_1995

Thanks in Advance!!

24

Yes modify request will only give you the requested access and the nativity identity (this will be the account attribute which you have set as user id in the account schema). If you want to get other values you need to use your user id which you get from plan to retrive them.

25

@udayputta ,
I didn’t understand this part “If you want to get other values you need to use your user id which you get from plan to retrive them.” Can you please give me an example?

26

@keerthiP7 I meant that when you want to add the Role and if you need additional user attributes then you can use the userid that you are receiving from the plan. I hope it is clear for you now.

27

Hi @udayputta ,

The other attributes that I’m talking about are not identity attributes like first name, last name and email etc., they are account request attributes which are along with entitlement data that needs to be in DB.

Thanks!

28

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.