Re: New owner?

From: Himanshu Gupta <himanshu.gupta_at_luton.ac.uk>
Date: Fri, 12 Nov 1999 16:31:34 +0000
Message-ID: <382C40E6.BE26B77D@luton.ac.uk>

Felix van Hove wrote:
>
> I've got some tables owned by userX in my local database. I want them to be
> owned by userY. Any chance? How?
>
> Felix
> felix2_at_zedat.fu-berlin.de

You may also do this:-

Grant select on tables owned by userX to userY, create tables in userY schema (create table a as select * from userx.a) and then drop these tables from UserX schema.

hth. Received on Fri Nov 12 1999 - 10:31:34 CST