History of User privileges held
Well there is no official method of getting the list of previous privileges list of a user or a role. But my suggestion would be doing a Fine-grained auditing on the role granted to the user. Or you can do standard auditing on the role by issuing audit &lt;role_name&gt;; . Here please note that if you are going to audit DBA or SYSDBA roles then set audit_sys_operations parameter to TRUE. Thank you.