change the owner of a database in informix
Posted in 2005
This is a multi-part message in MIME format. ------_=_NextPart_001_01C50936.627210F6 Content-Type: multipart/alternative; boundary="----_=_NextPart_002_01C50936.627210F6" ------_=_NextPart_002_01C50936.627210F6 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable =20 Hello there, =20 i would like to change the owner of the database in Informix: =20 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: =20 For example: "sosx" =20 Regards, Muthana =20 =20 ------------------------------------------------------------------- Muthana AL-Temimi TUHH - IuK-Referat Schlo=DFm=FChlendamm 32 21073 Hamburg Email: muthana.al-temimi@tu-harburg.hamburg.de Tel.: 040 428 78 3294 EFax: 040 4279 35 160 =20 ------_=_NextPart_002_01C50936.627210F6 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <html xmlns:v=3D"urn:schemas-microsoft-com:vml" = xmlns:o=3D"urn:schemas-microsoft-com:office:office" = xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns=3D"http://www.w3.org/TR/REC-html40"> <head> <meta http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <meta name=3DProgId content=3DWord.Document> <meta name=3DGenerator content=3D"Microsoft Word 10"> <meta name=3DOriginator content=3D"Microsoft Word 10"> <link rel=3DFile-List href=3D"cid:filelist.xml@01C5093E.BC7FED90"> <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:DoNotRelyOnCSS/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:SpellingState>Clean</w:SpellingState> <w:GrammarState>Clean</w:GrammarState> <w:DocumentKind>DocumentEmail</w:DocumentKind> <w:HyphenationZone>21</w:HyphenationZone> <w:EnvelopeVis/> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--> <style> <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} a:link, span.MsoHyperlink {color:blue; text-decoration:underline; text-underline:single;} a:visited, span.MsoHyperlinkFollowed {color:purple; text-decoration:underline; text-underline:single;} pre {margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Courier New"; mso-fareast-font-family:"Times New Roman";} span.EmailFormatvorlage17 {mso-style-type:personal-compose; mso-style-noshow:yes; color:black;} span.SpellE {mso-style-name:""; mso-spl-e:yes;} span.GramE {mso-style-name:""; mso-gram-e:yes;} @page Section1 {size:595.3pt 841.9pt; margin:70.85pt 70.85pt 2.0cm 70.85pt; mso-header-margin:35.4pt; mso-footer-margin:35.4pt; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style> <!--[if gte mso 10]> <style> /* Style Definitions */=20 table.MsoNormalTable {mso-style-name:"Normale Tabelle"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman";} </style> <![endif]--><!--[if gte mso 9]><xml> <o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" /> </xml><![endif]--><!--[if gte mso 9]><xml> <o:shapelayout v:ext=3D"edit"> <o:idmap v:ext=3D"edit" data=3D"1" /> </o:shapelayout></xml><![endif]--> </head> <body bgcolor=3Dwhite background=3D"cid:image001.jpg@01C5093E.BC7FED90" = lang=3DDE link=3Dblue vlink=3Dpurple style=3D'tab-interval:35.4pt'> <img src=3D"cid:image001.jpg@01C5093E.BC7FED90" v:src=3D"cid:image001.jpg@01C5093E.BC7FED90" v:shapes=3D"_x0000_Mail" = width=3D0 height=3D0 class=3Dshape style=3D'display:none;width:0;height:0'> <div class=3DSection1> <p class=3DMsoNormal><span class=3DSpellE><font size=3D2 color=3Dblack = face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial;color:black'>Hello</span></fo= nt></span><font size=3D2 color=3Dblack face=3DArial><span = style=3D'font-size:10.0pt;font-family:Arial; color:black'> <span = class=3DSpellE>there</span>,<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:black'><o:p> </o:p></span></font></p>= <p class=3DMsoNormal><span class=3DSpellE><span class=3DGramE><font = size=3D2 color=3Dblack face=3DArial><span lang=3DEN-GB = style=3D'font-size:10.0pt;font-family: Arial;color:black;mso-ansi-language:EN-GB'>i</span></font></span></span><= font size=3D2 color=3Dblack face=3DArial><span lang=3DEN-GB = style=3D'font-size:10.0pt; font-family:Arial;color:black;mso-ansi-language:EN-GB'> would like to = change the owner of the database in Informix:<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span = lang=3DEN-GB style=3D'font-size:10.0pt;font-family:Arial;color:black;mso-ansi-language= :EN-GB'><o:p> </o:p></span></font></p> <p class=3DMsoNormal><span class=3DGramE><font size=3D2 color=3Dblack = face=3DArial><span lang=3DEN-GB = style=3D'font-size:10.0pt;font-family:Arial;color:black;mso-ansi-language= : EN-GB'>for</span></font></span><font size=3D2 color=3Dblack = face=3DArial><span lang=3DEN-GB = style=3D'font-size:10.0pt;font-family:Arial;color:black;mso-ansi-language= : EN-GB'> example: I have the database called = “SOSPOS”<o:p></o:p></span></font></p> <p class=3DMsoNormal><span class=3DGramE><font size=3D2 color=3Dblack = face=3DArial><span lang=3DEN-GB = style=3D'font-size:10.0pt;font-family:Arial;color:black;mso-ansi-language= : EN-GB'>and</span></font></span><font size=3D2 color=3Dblack = face=3DArial><span lang=3DEN-GB = style=3D'font-size:10.0pt;font-family:Arial;color:black;mso-ansi-language= : EN-GB'> the owner of it the user “<span = class=3DSpellE>informix</span>”. Now I would like to change it to another = name:<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span = lang=3DEN-GB style=3D'font-size:10.0pt;font-family:Arial;c