Link to home
Create AccountLog in
Avatar of Akai123
Akai123

asked on

How to find audit details in Oracle databse ?

Hi,
For example I have a table Employee in Oracle database in a schema X.
Many users have access to Schema X .

Some one has given grant select previlage to a role 'Y'
I want to find who has given grants and when was given ?
If any one has a SQL accessing system audit tables to know
who and when please provide me the SQL
Thanks
Aka
Avatar of Wasim Akram Shaik
Wasim Akram Shaik
Flag of India image

use this sql to find out the grantor

select * from dba_tab_privs where grantee='<ROLE_NAME>'

this will give you enough details of a  privilege to a particular user/role
SOLUTION
Avatar of Sean Stuber
Sean Stuber

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Akai123
Akai123

ASKER

I want to find the actual person/terminal from where the grant has beeen given and the timestamp(when it was given).
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
"B" is a penalty grade and does not seem appropriate here

please explain