Click HERE to see how Saviynt Intelligence is transforming the industry. |
10/16/2024 09:04 AM
Hi All,
We are trying to import account and entitlements using Stored procedure. We are not getting belwo values from stored procedure.
1. Is it possible to hardcode securitysystem, endpoint,entitlementtype in the import XML itself, or is it mandatory to get these from Store procedure.
2. If it's mandatory to get these from stored procedure is there restriction on naming convention?
3. What all columns are mandatory to get the Account and Entitlement and map entitlement to account.
'XXXXXX' AS securitysystem,
'XXXXXXXX' AS endpoint,
XXXXXXX AS accountName,
XXXXXXXXX AS FirstName,
XXXXXXXXX AS LastName,
'XXXXXXXXX' AS entitlementtype,
XXXXXXXXXX AS entitlementvalue,
Regards,
Abhay Yadav
10/16/2024 09:07 AM - edited 10/16/2024 09:08 AM
@Abhay_Yadav yes you can but if using stored procedure it won't work .. you need to get the value.
10/16/2024 09:09 AM
10/16/2024 09:11 AM
@Abhay_Yadav as mentioned above without using stored procedure you can
Something like
'role' as entitlementtype.
If stored procedure is the only option then you can't.
10/16/2024 09:07 AM
1. Is it possible to hardcode securitysystem, endpoint,entitlementtype in the import XML itself, or is it mandatory to get these from Store procedure.
Yes its mandatory to get from stored procedure and you can't hardcode in XML
2. If it's mandatory to get these from stored procedure is there restriction on naming convention?
Yes endpoint /security system name should match with saviynt application
3. What all columns are mandatory to get the Account and Entitlement and map entitlement to account.
Same as you mentioned
'XXXXXX' AS securitysystem,
'XXXXXXXX' AS endpoint,
XXXXXXX AS accountName,
XXXXXXXXX AS FirstName,
XXXXXXXXX AS LastName,
'XXXXXXXXX' AS entitlementtype,
XXXXXXXXXX AS entitlementvalue,
10/16/2024 09:26 AM
Hi @rushikeshvartak , @NM ,
We have below output of the account Stored procedure.
And below is entitlement store procedure output.
In entitlement stored procedure there is hierarchy
Role Name > Module Category > Module Name > Permission > Permission Setting
What modifications would be required in this to import the entitlement hierarchy and in user stored procedure so that user's entitlement access can be mapped to "Role Name"
Regards,
Abhay Yadav
10/16/2024 09:37 AM - edited 10/16/2024 09:43 AM
@Abhay_Yadav , output looks fine .. you can map it to role.
<mapfield saviynt
<mapfield saviyntproperty="entitlementvalues.entitlementvalue" sourceproperty="RoleName" type="character"/>
10/16/2024 09:48 AM
Hi @NM ,
I meant in the entitlement store procedure do i need to get
'Rolename' as enttype1
'Module Category' as enttype2
'Module Name' as enttype3
similarly for others
Also in the documentation it has system name and application name as two different things. Is it just a typo or are these actually 2 different things.
Regards,
Abhay Yadav
10/16/2024 09:53 AM
@Abhay_Yadav it depends you have to have them as seperate entitlement type or single(parent and child)
10/16/2024 10:07 AM
Hi @NM ,
As we are getting only "RoleName" information in Account Stored procedure. What would be the best way to display it in saviynt that if user has Access to "RoleName" then saviynt should display full hierarchy based on entitlement stored procedure.
Can you please help me understand how hierarchy for seperate entitlement type can be achieved and how single(parent and child ) hierarchy can be achieved.
Regards,
Abhay Yadav
10/16/2024 11:08 AM
Above all columns are mandatory if you are bringing entitlement to entitlement mapping. Role to Privilege mapping
10/16/2024 09:48 AM
You need to have Status as 1/2 in Account result also entitlement type, endpoint , security system is required