RE: Changing owner of objects in a database
The syntax guide specifically mentions that rename command cannot be used
for chaning owner of the table. I guess I will have to use
dbexport/dbimport.
> -----Original Message-----
> From: Edward Rosenthal [SMTP:edrosenthal@home.com]
> Sent: Tuesday, April 25, 2000 3:48 PM
> To: informix-list@iiug.org
> Subject: Re: Changing owner of objects in a database
>
> im pretty sure nobody would suggest you muck with the system catalog
> for any reason whatsoever.
> i think you can rename tables and specify ownership.
>
>
> "Arshad, Shehla" wrote:
>
> > I would like to know if there is another way of changing the ownership
> of
> > all objects (tables, indexes, constraints, etc) from one specific user
> to
> > another, besides using dbexport-changing sql-dbimport. We want to avoid
> > export and import of the database to do this quickly.
> >
> > Would an update of system catalog tables update sysmaster internally and
> > make them in sync?
> >
> > We are running IDS 7.30.FC7.
> >
> > Thanks,
> >
> > Shehla