This discussion is archived
1 Reply Latest reply: Dec 5, 2012 4:36 AM by Niket Kumar RSS

how can i understand from AUD$ table that only view is accessed by users?

ozgunyergok Newbie
Currently Being Moderated
hi all ,

lets say, I had a table AAA and I created a view called V_AAA as select * from AAA .

then i grant select on V_AAA to user_1 . so , the user_1 has no right to select directly from AAA table .

but when the user run a select from V_AAA , i see that in the SYS.AUD$ table there are two rows about this action . one row for view, one row for table. however the user_1 don't access the AAA table direcly.

how can i understand from SYS.AUD$ table that the user access directly to table or the user access the view based on that table ?

thanks .


  • Correct Answers - 10 points
  • Helpful Answers - 5 points