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

Thanks. The apps do reference the owners. Obviously I want to avoid this in the future. Would you recommend creating synonyms and referencing them in the apps? I haven't used synonyms before, but I'm starting to read up on them. Would we need to create the synonyms for each user, or could we create public synonyms and use those?

I'm afraid that insisting that the developers create their tables under a generic ID would cause a revolt, although it's definitely feasible for this case sinc the developer's left.

Jonathan Gennick wrote:
>
> 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?

--
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the universe trying to produce bigger and better idiots.

So far, the universe is winning."

Rick Cook, mission manager,
NASA Mars Pathfinder project. Received on Tue Sep 14 1999 - 12:30:35 CDT