Hello,
is there a way to set up a history log for permission set change (grant and revoke an object or method)?
Tks
Hello,
is there a way to set up a history log for permission set change (grant and revoke an object or method)?
Tks
Hi
I don’t think you will be able to track method level grants through History log. Probably for the best as these are tracked through base security sys tables and can become a massive overhead if logging is setup on those.
You would however be able track pres Object level changes against permission sets by setting up logging on PRES_OBJECT_GRANT_TAB. Once again, be vary on the overhead if you are doing lot of changes to security.
Cheers
Hi
You could try out a custom event (PRES_OBJECT_GRANT_TAB) for this matter since it records old value and new value. You can just record these values along with the session user and timestamp to a table you created.
Hope this works for you.
Thanks,
Best Regards,
Nadeesha Liyanage.
Hi
I don’t think you will be able to track method level grants through History log. Probably for the best as these are tracked through base security sys tables and can become a massive overhead if logging is setup on those.
You would however be able track pres Object level changes against permission sets by setting up logging on PRES_OBJECT_GRANT_TAB. Once again, be vary on the overhead if you are doing lot of changes to security.
Cheers
Hi, Sajith, Tks 4 the info.
I’m gonna try using history log with this table.
Let you know if it works.
Br
Hi
You could try out a custom event (PRES_OBJECT_GRANT_TAB) for this matter since it records old value and new value. You can just record these values along with the session user and timestamp to a table you created.
Hope this works for you.
Thanks,
Best Regards,
Nadeesha Liyanage.
Hi, EntNadeel
tks 4 the idea.
Gonna try also this option.
Br
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.