Re: What are considered Oracle system tables?

From: Dodgers <dodgers.eis_at_worldnet.att.net>
Date: Fri, 08 Mar 2002 03:35:37 GMT
Message-ID: <dkWh8.21397$gK2.1593440@bgtnsc04-news.ops.worldnet.att.net>

You are best advised to control access to system tables via the appropriate role, e.g., sysoper, sysdba, select_any_table, and so on. When you define the user(s)/schema(s) that you will use to connect via JDBC grant (or don't grant) them the appropriate role and you should be all set.

Cheers!

"D. Alvarado" <laredotornado_at_zipmail.com> wrote in message news:9fe1f2ad.0203071155.640070bf_at_posting.google.com...
> I'm connecting to an Oracle 8 server using JDBC. I'm creating an app
> that allows the user to get a listing of all db tables and query any
> he chooses. However, I don't really want ALL talbes, only user
> created tables (i.e. non-system tables). I don't really know how to
> distinguish system tables from user tables, I assume it would be by
> schema. Are there certain schemas that define system tables? What
> are they? Is there a better way to get a listing of user created
> tables?
>
> Thanks in advance, Dave A.
Received on Thu Mar 07 2002 - 21:35:37 CST