Table Ownerships
This is a multi-part message in MIME format. ------_=_NextPart_001_01C3B9C7.4C029AEC Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable All, Is there an easy way to change the owners of all database tables with one SQL statement? =20 =20 ------_=_NextPart_001_01C3B9C7.4C029AEC Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable <html 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=3D"Content-Type" CONTENT=3D"text/html; = charset=3Dus-ascii"> <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@01C3B98C.9F1BB8E0"> <!--[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:EnvelopeVis/> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--> <style> <!-- /* Font Definitions */ @font-face {font-family:Helvetica; panose-1:2 11 6 4 2 2 2 2 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:536902279 -2147483648 8 0 511 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin-top:0in; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; font-size:10.0pt; font-family:Helvetica; mso-fareast-font-family:"Times New Roman"; color:#FFFFCC; mso-believe-normal-left:yes;} a:link, span.MsoHyperlink {color:blue; text-decoration:underline; text-underline:single;} a:visited, span.MsoHyperlinkFollowed {color:purple; text-decoration:underline; text-underline:single;} p {mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; font-size:10.0pt; font-family:Helvetica; mso-fareast-font-family:"Times New Roman"; color:#FFFFCC;} span.EmailStyle17 {mso-style-type:personal-compose; mso-style-noshow:yes; mso-ansi-font-size:10.0pt; mso-bidi-font-size:10.0pt; font-family:Arial; mso-ascii-font-family:Arial; mso-hansi-font-family:Arial; mso-bidi-font-family:Arial; color:windowtext;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style> <!--[if gte mso 10]> <style> /* Style Definitions */=20 table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman";} </style> <![endif]--><![if mso 9]> <style> p.MsoNormal {margin-left:18.75pt;} </style> <![endif]> </head> <body lang=3DEN-US link=3Dblue vlink=3Dpurple = style=3D'tab-interval:.5in;margin-left: 18.75pt;margin-top:18.75pt'> <div class=3DSection1> <p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:windowtext'>All,<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:windowtext'><span = style=3D'mso-tab-count:1'> </span>Is there an easy way to change the owners of all database tables with one = SQL statement?<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:windowtext'><o:p> </o:p></span></font= ></p> <p><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> </div> </body> </html> ------_=_NextPart_001_01C3B9C7.4C029AEC-- sending to informix-list
Cartellone, Chris wrote: > > This is a multi-part message in MIME format. > > ------_=_NextPart_001_01C3B9C7.4C029AEC > Content-Type: text/plain; > charset="US-ASCII" > Content-Transfer-Encoding: quoted-printable > > All, > Is there an easy way to change the owners of all database tables > with one SQL statement? > =20 > =20 > > ------_=_NextPart_001_01C3B9C7.4C029AEC > Content-Type: text/html; > charset="US-ASCII" > Content-Transfer-Encoding: quoted-printable > > <html 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=3D"Content-Type" CONTENT=3D"text/html; = > charset=3Dus-ascii"> > > > > > <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@01C3B98C.9F1BB8E0"> > <!--[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:EnvelopeVis/> > <w:Compatibility> > <w:BreakWrappedTables/> > <w:SnapToGridInCell/> > <w:WrapTextWithPunct/> > <w:UseAsianBreakRules/> > </w:Compatibility> > <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> > </w:WordDocument> > </xml><![endif]--> > <style> > <!-- > /* Font Definitions */ > @font-face > {font-family:Helvetica; > panose-1:2 11 6 4 2 2 2 2 2 4; > mso-font-charset:0; > mso-generic-font-family:swiss; > mso-font-pitch:variable; > mso-font-signature:536902279 -2147483648 8 0 511 0;} > /* Style Definitions */ > p.MsoNormal, li.MsoNormal, div.MsoNormal > {mso-style-parent:""; > margin-top:0in; > margin-right:0in; > mso-margin-bottom-alt:auto; > margin-left:0in; > mso-pagination:widow-orphan; > font-size:10.0pt; > font-family:Helvetica; > mso-fareast-font-family:"Times New Roman"; > color:#FFFFCC; > mso-believe-normal-left:yes;} > a:link, span.MsoHyperlink > {color:blue; > text-decoration:underline; > text-underline:single;} > a:visited, span.MsoHyperlinkFollowed > {color:purple; > text-decoration:underline; > text-underline:single;} > p > {mso-margin-top-alt:auto; > margin-right:0in; > mso-margin-bottom-alt:auto; > margin-left:0in; > mso-pagination:widow-orphan; > font-size:10.0pt; > font-family:Helvetica; > mso-fareast-font-family:"Times New Roman"; > color:#FFFFCC;} > span.EmailStyle17 > {mso-style-type:personal-compose; > mso-style-noshow:yes; > mso-ansi-font-size:10.0pt; > mso-bidi-font-size:10.0pt; > font-family:Arial; > mso-ascii-font-family:Arial; > mso-hansi-font-family:Arial; > mso-bidi-font-family:Arial; > color:windowtext;} > @page Section1 > {size:8.5in 11.0in; > margin:1.0in 1.25in 1.0in 1.25in; > mso-header-margin:.5in; > mso-footer-margin:.5in; > mso-paper-source:0;} > div.Section1 > {page:Section1;} > --> > </style> > <!--[if gte mso 10]> > <style> > /* Style Definitions */=20 > table.MsoNormalTable > {mso-style-name:"Table Normal"; > mso-tstyle-rowband-size:0; > mso-tstyle-colband-size:0; > mso-style-noshow:yes; > mso-style-parent:""; > mso-padding-alt:0in 5.4pt 0in 5.4pt; > mso-para-margin:0in; > mso-para-margin-bottom:.0001pt; > mso-pagination:widow-orphan; > font-size:10.0pt; > font-family:"Times New Roman";} > </style> > <![endif]--><![if mso 9]> > <style> > p.MsoNormal > {margin-left:18.75pt;} > </style> > <![endif]> > </head> > > <body lang=3DEN-US link=3Dblue vlink=3Dpurple = > style=3D'tab-interval:.5in;margin-left: > 18.75pt;margin-top:18.75pt'> > > <div class=3DSection1> > > <p class=3DMsoNormal><font size=3D2 color=3Dblack face=3DArial><span = > style=3D'font-size: > 10.0pt;font-family:Arial;color:windowtext'>All,<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:windowtext'><span = > style=3D'mso-tab-count:1'> </span>Is > there an easy way to change the owners of all database tables with one = > SQL statement?<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:windowtext'><o:p> </o:p></span></font= >></p> > > <p><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> > > </div> > > </body> > > </html> > > ------_=_NextPart_001_01C3B9C7.4C029AEC-- > sending to informix-list 173 lines for a 3 line post.... F-word. -- "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche
In <bql917$bl6$1@terabinaries.xmission.com> article, Cartellone, Chris mentioned that: : All, : Is there an easy way to change the owners of all database tables : with one SQL statement? update systables set owner = "XXXXXX" where tabname not like 'sys%' ; Not recommended to mess with system tables, but in a pinch, it works... Michael Hoffman