OraFAQ Forum: Security » date when a role or privileges was granted and/or revoke

Home » RDBMS Server » Security » date when a role or privileges was granted and/or revoke

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

date when a role or privileges was granted and/or revoke [message #674404]

Fri, 25 January 2019 10:59

wtolentino
Messages: 375
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

Michel Cadot
Messages: 68500
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

Michel Cadot
Messages: 68500
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

wtolentino
Messages: 375
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 22 22:28:32 CDT 2023