Hi ,
If we delete any items like Accounts, entitlements, roles, groups in RSA Aveksa UI. Where we can find the deleted items details in the database.
Also, in the tables is it possible to check deleted access (Entitlements/Groups/Roles) of a particular user.
In which table we can find the below details. Please assist.
Take a look at this one: T_AV_EXPLODEDUSERENTITLEMENTS
It has creation date, deletion date and some user id information also.
Hi Zoltan,
Thanks for the response.
I will check the table for details.
Also, can you please help in which table I can get the below details.
I am not sure what do you mean. These parameters are for collection from database. You can collect from MSSQL, MySQL, Oracle, etc. In all cases set the database type accordingly. Driver class will be set automatically. For url you will get a template which you have to modify. Username and password refers to login credentials of collected database.
Hi Zoltan,
Thanks for the reply.
Take a look at this one: T_AV_EXPLODEDUSERENTITLEMENTS
It has creation date, deletion date and some user id information also.
In the above table I can able to see only the deletion history of entitlements of users.
I want to check the deletion history of Roles for the users as well.
thanks
Manikandan
Hi,
In my table I can see the following entitlement types:
app-role
ent
global-role
group
So it seems there are roles as well.
Zoltan
Hi Zoltan,
In this table T_AV_EXPLODEDUSERENTITLEMENTS, we cant find the details of Technical and Business role deletion details.
Also we need to check the deleted Technical/ Business role access of the user from database tables.
Please assist with the related tables.
Thanks
Manikandan
Manikandan Raju,
I've moved your question to the RSA Identity Governance & Lifecycle space where it will be seen by the product's support engineers, other customers and partners. Please bookmark this page and use it when you have product-specific questions.
Alternatively, from the RSA Customer Support page, click on Ask A Question on the blue navigation bar and choose Ask A Product Related Question. From there, scroll to RSA Identity Governance & Lifecycle and click Ask A Question. That way your question will appear in the correct space.
Regards,
Erica