Skip to main content

Hi!
I’m looking for a way to track changes in permission sets on users. I.e I’d like to see who changed a permission set on a user and when. 
I can’t find a suitable configuration in History Log or a table to set up a custom event on.

Does anyone have an idea as for how to solve this?

Hi @ELJO 

for permission sets we have the following tables:

 

 


Hi, you must activate the log of the table FND_USER_ROLE_TAB. It may not be available by default.

Make sure to select show Foundation1 Component. Then it works as usual and you can track any modification of access rights related to permission sets.

 


Hi all!
I must have missed RMB Show Foundation1 Component. I simply couldn’t find the table. 
But now it’s all up and running. Thank you!


You need to RMB in the history log navigator and display F1 components. 

 

Then you can turn on logging on FND_USER_ROLE_TAB.
 

 


Hi again!
I’ve activated the FND_USER_ROLE_TAB in history log for all Insert, Update and Delete on ROLE column. I’ve also pressed save, but for some reason the test changes I make are not logged. 


When checking the actual table, changes are made in ROLE column:

But history log dos not show any logs from the table. 

I’ve successfully activated other tables for history logging, and I can’t remember that there was anything else I needed to to in order to activate them. Am I missing something?


Hi @ELJO 

the logs are reoported in the table history_log_tab.


Hi @ELJO 

the logs are reoported in the table history_log_tab.

Thank you! I can see the changes in this table, but should they not be visible also in IEE View History Log?


Hi @ELJO 

in this case I don’t think so.

What you can do is to use the shortcut Ctrl + F9 to show the history logs.

 


Ok, thank you! At least I can track changes now. :)

 


Reply