I am just wondering if there are ways to know as when the particular privileges' granted to a user. unfortunately , I do not have auditing enabled and without this , I have no idea if this is doable.
Just like to brief you about bit of a history as I did one export/import and it went fine without any issues related to roles/privilege's. On source , a user had the connect role assigned to it , and during import , I export , all the privilege's and roles should also be imported without any issue , but we I got a notification from a user that when they tried to connect it flashes , " user lacks "create session" privileges. Now , I am trying to check , if there ways to find all the privileges and roles were imported successfully or not using some database queries. I also do not have the import logs , but I can tell , it had no issues during import. All the objects count matches on "source" and "target".
Regards