RE: Changing ownership...
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C02D33.F62D4D80
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Try this SQL statement in your database:
UPDATE systables SET owner =3D '<owner>' WHERE tabname =3D '<tabname>'
-----Message d'origine-----
De : Prasad Mahale [mailto:gs0528@hotmail.com]
Envoy=E9 : vendredi 29 septembre 2000 20:37
=C0 : informix-list@iiug.org
Objet : Changing ownership...
Hi All,
I want to change ownership of some of the tables in my database. The =
way i
know is by recreating the table with new ownership info. This does'nt =
look
easy considering my database size.
Is there any easiest way, any tricks (any script?) to do this?
Thanks in advance
-Prasad
________________________________________________________________________=
_
Get Your Private, Free E-mail from MSN Hotmail at =
http://www.hotmail.com
<http://www.hotmail.com>; .
Share information about yourself, create your own public profile at
http://profiles.msn.com <http://profiles.msn.com>; .
------_=_NextPart_001_01C02D33.F62D4D80
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<TITLE></TITLE>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D942001812-03102000>Try=20
this SQL statement in your database:</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D942001812-03102000>UPDATE=20
systables SET owner =3D '<owner>' WHERE tabname =3D=20
'<tabname>'</SPAN></FONT></DIV>
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
<DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT =
face=3DTahoma=20
size=3D2>-----Message d'origine-----<BR><B>De :</B> Prasad =
Mahale=20
[mailto:gs0528@hotmail.com]<BR><B>Envoy=E9 :</B> vendredi 29 =
septembre 2000=20
20:37<BR><B>=C0 :</B> =
informix-list@iiug.org<BR><B>Objet :</B>=20
Changing ownership...<BR><BR></DIV></FONT>
<P><FONT size=3D2>Hi All,<BR>I want to change ownership of some of =
the tables in=20
my database. The way i<BR>know is by recreating the table with new =
ownership=20
info. This does'nt look<BR>easy considering my database size.<BR>Is =
there any=20
easiest way, any tricks (any script?) to do this?<BR><BR>Thanks in=20
=
advance<BR><BR>-Prasad<BR>______________________________________________=
___________________________<BR>Get=20
Your Private, Free E-mail from MSN Hotmail at <A =
href=3D"http://www.hotmail.com"=20
target=3D_blank>http://www.hotmail.com</A>.<BR><BR>Share information =
about=20
yourself, create your own public profile at<BR><A=20
href=3D"http://profiles.msn.com"=20
=
target=3D_blank>http://profiles.msn.com</A>.<BR></FONT></P></BLOCKQUOTE>=
</BODY></HTML>
------_=_NextPart_001_01C02D33.F62D4D80--