i'm using oracle 8i, i just would ike to know using the data dictionary...
what is the sql script to know if the schema belongs to the database,
if the table belongs to the schema and if the field belongs to the table.
The ALL_TABLES view is a list of all tables that the user has access to. The DBA_TABLES is the view that shows ALL tables, but that view is only visable to people with the DBA priviledges. If you want a list of all schemas that own tables that the user can access then issue the following select.
select distinct owner from all_tables;
You do not need a parachute to skydive. You only need a parachute to skydive twice.