Enhanced Query: entitlement_owners table

[Marcel]

I'm trying to insert a single row into the table entitlement_owners using the Enhanced Query.
Configuration:

Query used:

select '7318' ENTITLEMENT_OWNERS__USERKEY, '135229' ENTITLEMENT_OWNERS__ENTITLEMENT_VALUEKEY, '1' ENTITLEMENT_OWNERS__RANK from entitlement_owners

Error: Multiple primary Key present for table E

[rushikeshvartak]

entitlement_owners Table is not feasible as it contains composite keys

https://docs.saviyntcloud.com/bundle/EIC-Admin-v23x/page/Content/Chapter10-Job-Control-Panel/Job-Cat...

[Marcel]

What where clause? I'm trying to do an insert, not an update..

'where 1=1' or 'where 1=2'?

The first one will return as many results as available, the second will not return anything..

[rushikeshvartak]

entitlement_owners Table is not feasible as it contains composite keys

https://docs.saviyntcloud.com/bundle/EIC-Admin-v23x/page/Content/Chapter10-Job-Control-Panel/Job-Cat...

[Raghu]

@Marcel  it wont be accept insert and update above table as per 23.9v

https://docs.saviyntcloud.com/bundle/EIC-Admin-v23x/page/Content/Chapter10-Job-Control-Panel/Job-Cat...

1. we can't insert directly entitlement_owners table , it is a combination of parent and child table , entiltment_value key getting from entitlement value table.

2. not sure it wont be work update and insert scripts

3.if going to insert also , it will expect parent table value key available or not.

4. similar case we requested earlier back saviynt suggested for owner update use GroupImport in connector level like.

[rushikeshvartak]

Product support import sheet what is business use case to do insert/update ?

[Marcel]

Import sheet is only to assign entitlements to users/accounts, or to create new entitlements.
I'm trying to add ~1000 entitlement owners to ~500 existing entitlements and don't want to do it by hand one at a time.

[rushikeshvartak]

You can do add / remove of owner in public using import sheet

Entitlement Value	ENDPOINT	Security System	Entitlement Type	Entitlement Owner	Owner Rank	Action
ENT1	APP1	APP1	Roles	rvartak	1	add
ENT2	APP1	APP1	Roles	rv	1	remove

https://forums.saviynt.com/t5/identity-governance/how-to-remove-entitlement-owner-from-entitlement-v...

[Marcel]

Hi Rushikesh, thank you for this suggestion.

Unfortunately it doesn't work, and give me the following error:
Ambiguous method overloading for method [Ljava.lang.String;#getAt. Cannot resolve which method to invoke for [null] due to overlapping prototypes between: [interface groovy.lang.Range] [interface java.util.Collection]

[rushikeshvartak]

Please share import file and configuration selected during import

[Marcel]

EntitlementValue	Endpoint	SecuritySystem	EntitlementType	EntitlementOwner	OwnerRank	Action
CN=GroupName1,OU=DeepOU,OU=HighOU,OU=TopOU,DC=domain,DC=local	ActiveDirectory_Authorizations_Endpoint	ActiveDirectory_Authorizations	Groups	EmpA3	1	add
CN=GroupName2,OU=DeepOU,OU=HighOU,OU=TopOU,DC=domain,DC=local	ActiveDirectory_Authorizations_Endpoint	ActiveDirectory_Authorizations	Groups	abc2	1	add

The values have been anonymized, but are showing their use.
"EmpA3" and "abc2" are valid accounts under the "ActiveDirectory_Authorizations_Endpoint" endpoint.

Delimiter: Comma
First row as heading: Yes
All other settings: No (Create Security System, Create Endpoint, Create Entitlement Type, Create Entitlement Owner, Inactive Entitlement not in File, Create Entitlement)

[rushikeshvartak]

Please confirm product version

[Marcel]

24.1

[rushikeshvartak]

Above works as expected in v24.1 can you keep Operation instead of action and try 

[Marcel]

It does not work. There is no option "Operation", but there are two options "Action":

[rushikeshvartak]

Select Upload Entitlement From CSV

[Marcel]

That is what I did

[rushikeshvartak]

Try with entitlement without special characters 

like RolE_admin

[Marcel]

Screen recording of what I'm doing:
[Removed]

[rushikeshvartak]

Try below attached file

[Marcel]

Your unmodified file does work.
Unfortunately, using your header and just the first line of my own file still doesn't work and gives the same error. See attached file.

[rushikeshvartak]

Use double quoted for entitlement name

[Marcel]

Already the case in the file uploaded

Also tried it with all fields doublequoted, but that didn't work either.

[rushikeshvartak]

Does it works for non AD based apps 

[Marcel]

Stupid forums.. Clicked the "Accept as solution" by accident..

I don't know if it works for non AD based apps, we want to do it for this app.
As this is now becoming more critical (time based), we have started inputting the data manually. It seems that I won't be getting an answer from the forums any time soon either.

[rushikeshvartak]

use postman