Re: change the owner of a database in informix
The owner of a database is the user who created the database. So you
have to drop and recreate the database.
As user informix:
$ dbexport -ss sospos
then drop the database ($ echo 'drop database sospos|dbaccess -)
Change to user sosx (su sosx)
$ dbimport sospos
That's it!
Murray Wood (IList) wrote:
> Don't post HTML.
>
> You do not have a choice on the owner of a database.
> If you want to change the owner of a table, index, etc drop and recreate it.
>
> MW
>
> ________________________________
>
> From: owner-informix-list@iiug.org
> [mailto:owner-informix-list@iiug.org] On Behalf Of
> Muthana.AL-Temimi@tu-harburg.hamburg.de
> Sent: Thursday, 3 February 2005 3:49 a.m.
> To: informix-list@iiug.org
> Subject: change the owner of a database in informix
>
>
>
>
> Hello there,
>
>
>
> i would like to change the owner of the database in Informix:
>
>
>
> for example: I have the database called 'SOSPOS'
>
> and the owner of it the user 'informix'. Now I would like to change
> it to another name:
>
>
>
> For example: 'sosx'
>
>
>
> Regards,
>
> Muthana
>
>
>
>
>
> -------------------------------------------------------------------
> Muthana AL-Temimi TUHH - IuK-Referat
> Schlo'm'hlendamm 32 21073 Hamburg
> Email:
> muthana.al-temimi@tu-harburg.hamburg.de
> Tel.: 040 428 78 3294
> EFax: 040 4279 35 160
>
>
>
>
> sending to informix-list