In Oracle 12c or 11g, is it possible to fetch the history of user privileges held by a schema? Say from last two months, I might have granted different roles and privileges. I can get the current privileges the schema holds, but is it possible to know the privileges I previously granted?

Edit: I have standard auditing enabled 'DB'. FGA is not enabled.

  • Do you have auditing enabled for it?
    – Philᵀᴹ
    Nov 16, 2016 at 16:26
  • Yes standard auditing
    – tesla747
    Nov 16, 2016 at 16:30

1 Answer 1


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 <role_name>; . Here please note that if you are going to audit DBA or SYSDBA roles then set audit_sys_operations parameter to TRUE. Thank you.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.