Query List of useable tables.

Hello world,

   I am looking for a way in Oracle to easily get the list of database tables that a user can REALLY use. For example calling:

   SELECT TABLE_NAME FROM SYS.DBA_TABLES WHERE OWNER='SCOTT'"; will return all of the tables that scott created. I want a list of tables that 'SCOTT' is allowed to select against, not just the list he created. I could use:

    SELECT GRANTEE, TABLE_NAME FROM SYS.DBA_TAB_PRIVS        WHERE GRANTEE = 'SCOTT' OR GRANTEE = 'PUBLIC'; Will this do the right thing?

How does the new role infomation enter into the equation?

Sorry if this has already been asked.
Thanks in advance.

-- 

                            ________
   Scott A. Mansfield       \\\\////     Template Software
   (703) 318-1000            \\\///      13100 Worldgate Drive, Suite 340
   uunet!template!scott       \\//       Herndon, VA 22070-4382
   scott_at_template.com          \/        Fax: (703) 318-7378