Home » RDBMS Server » Security » date when a role or privileges was granted and/or revoke
date when a role or privileges was granted and/or revoke [message #674404] Fri, 25 January 2019 10:59 Go to next message
wtolentino
Messages: 390
Registered: March 2005
Senior Member
is there a way to know when a privileges or role was granted and/or revoke? for example on wednesday 23-Jan-2019 user scott was granted select privileges on hr.department table. i want to see the dates when a privilege or role was granted and/or revoke.

thank you,
warren
Re: date when a role or privileges was granted and/or revoke [message #674405 is a reply to message #674404] Fri, 25 January 2019 11:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Log Miner.

Re: date when a role or privileges was granted and/or revoke [message #674406 is a reply to message #674405] Fri, 25 January 2019 11:07 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

And if you think you'll need it in the future, set audit on GRANT and REVOKE.

Re: date when a role or privileges was granted and/or revoke [message #674408 is a reply to message #674406] Fri, 25 January 2019 14:13 Go to previous message
wtolentino
Messages: 390
Registered: March 2005
Senior Member
thanks so much.
Previous Topic: Need Help Regarding FGA_AUDIT
Next Topic: Audit DROP user by SYS
Goto Forum:
  


Current Time: Thu Mar 28 05:49:49 CDT 2024