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: 333
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

Report message to a moderator

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: 67665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Log Miner.

Report message to a moderator

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: 67665
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.

Report message to a moderator

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: 333
Registered: March 2005
Senior Member
thanks so much.

Report message to a moderator

Previous Topic: Need Help Regarding FGA_AUDIT
Next Topic: Audit DROP user by SYS
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jan 25 15:20:28 CST 2021
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.