Re: Query List of useable tables.

scott_at_template.com (Scott Mansfield) writes:

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

Um, define 'really'. Here's how to get a list of all tables that the user has at least some kind of access to, at least in Oracle 7:

select table_name from all_tables;

You may want to filter out the tables owned by SYS and SYSTEM from this list. What's left should be the 'user' tables.

---
Michael Nolan, Sysop for the DBMS RoundTable on GEnie
nolan_at_notes.tssi.com, dbms_at_genie.geis.com
(posted from nolan_at_helios.unl.edu)