Thanks for the question, Tesla.
Asked: November 19, 2016 - 3:55 am UTC
Last updated: November 19, 2016 - 4:15 am UTC
Version: 12.1.0.2
Viewed 1000+ times
You Asked
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?
I have only standard database auditing enabled. Audit sys operations is set to true. FGA is not enabled.
and Connor said...
Unless you audited the commands (which it sounds like you didnt), then it is unlikely.
If you had "enable_ddl_logging" set to true (default is false), then its possible that the commands will be in the alert log.
Is this answer out of date? If it is, please let us know via a Comment