1 Reply Latest reply: Dec 5, 2012 6:36 AM by Niket Kumar RSS

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

      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 .