Find tables accessed by user in Oracle
<p>Using Oracle XE 10g.</p>

<p>We have an application that uses a database user with restricted access. Because it is very cumbersome to find out by trial and error which tables this user needs to have access to, we are looking for a way to query the Oracle Data Dictionary for information on table access.</p>

<p>What would be great is a query that gives a list of tables that this user accessed since some point in time, preferably with whether this was write or read-only access.</p>

<p>That way, we could run a test with a user with unrestricted access, find out which tables it used, and then setup this user to only have access to those tables.</p>

<p>I was looking at <code>V$SEGMENT_STATISTICS</code>, but this does not log the user that accessed the object.</p>