Guys, I have a script which runs everyday and searches for the user who haven't logged on to the SN for 30 days. Those users are revoked from groups and roles by the script. Now I want to know is there a table where I can see which all groups or roles have been removed for a particular user??
Audit Roles business rule on sys_user_has_role table and it's updating the sys_audit_table. Like wise you can develope same way a new table u_audit_group and audit group business rule.
I have a script which runs everyday and searches for the user who haven't logged on to the SN for 30 days. Those users are revoked from groups and roles by the script.
I have same requirement, can you pls share the script.
