Re: Schema Ownership

From: Jerry Metz <JMetz1_at_ix.netcom.com>
Date: Wed, 23 Dec 1998 16:43:27 -0600
Message-ID: <3681720F.C542C5B5@ix.netcom.com>

This absolutely goes against every reason to use a professional database like Oracle rather than the other play toys in existence. One reason NOT to do what you have suggested is that many of the object owners may use very similar naming styles for their objects. Combining or initiating a single user owner would provide nothing but grief when trying to update only a certain group of tables. You might also want to look into the Oracle documentation for other benefits of Oracle including SECURITY. Someone else wrote in about this subject and their idea of a full database export is indeed the way to go.

Roman Gelfand wrote:

> Is there a way to lump all users under one central user so that when I need
> to export all users I just specify one central user's name?
>
> Thanks in advance
>
> Roman
Received on Wed Dec 23 1998 - 16:43:27 CST