Hi,
is there any query to get updates on user roles, when granted ,revoked ,granted by ,revoked by whom , transaction dates
You need to enable audit policies and then you can get the required data.
Please check below thread for more details:
Role Assignment history of users — Cloud Customer Connect (oracle.com)
Thanks.