Re: How do I change the owner of an table?

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Mon, 13 Sep 1999 22:03:06 GMT
Message-ID: <37e3741f.20279267@netnews.worldnet.att.net>

I would start by exporting this user's objects, and reimporting them under some other user id. It sounds like you create a generic user-id that just exists to own this data.

If your applications reference these objects by referencing the owner name (e.g.: select * from owner.table), you will need to make some modifications.

Jonathan

On Mon, 13 Sep 1999 13:34:29 -0800, Calvin Crumrine <Calvin_Crumrine_at_dced.state.ak.us> wrote:

>One of our developers has left and I want to delete them but they own lots of the tables &
>procedures we use. How do I change this?
Received on Mon Sep 13 1999 - 17:03:06 CDT