Re: Table Creation

"mtwalla" <mtwalla_at_bluefishgroup.com> wrote in message news:<ZWjA8.4696$VQ6.601495_at_news.uswest.net>...
> If I'm creating Tables that all users of an application will typically
> access, who should own them? Should the owner be SYS and then create a
> Public Synonymn for the the table? Or should there be an application user
> who owns all the tables essentially patitioning the application's Databse
> Objects? If that is the case, should Synonymns be created on those tables as
> well?
>
> Mike

Mike, you should almost never use the SYS ID for several reasons. Only Oracle created base tables, dictionary objects, and such created in the 'create database' process plus added via Oracle provided cat and dbms scripts should really exist under this ID. One reason you should not create user application objects under SYS is that the contents of SYS owned tables are not exported and imported like other user objects. Oracle maintains the base tables as the result of DDL statements.

Application objects should always be created under a application owner ID and generally be accessed via either an application user ID or individual user IDs.

I believe you can find support for my position in the Concepts manual.

HTH -- Mark D Powell -- Received on Fri May 03 2002 - 08:53:55 CDT