Change the owner of a table

Posted in 1999

S. Radtke — Wed, 6 Jan 1999 12:05:01 +0100 — source: Informix-list mailing list archive (1991-1998)

Hello, Can anybody tell me, how i can change the owner of a table without drop and create the table ? Thanx Sven

↪ replying to S. Radtke

Gary L. Burnore — Wed, 06 Jan 1999 19:03:56 GMT — source: Informix-list mailing list archive (1991-1998)

On Wed, 6 Jan 1999 12:05:01 +0100, in article <76vfuo$jlt$1@news.ppp.net>, "S. Radtke" <rt@pascal.de> wrote: >Hello, > >Can anybody tell me, how i can change the owner of a table without drop and >create the table ? Depending on the version of Informix, there are ways. It's easy to screw up though. I recommend rename tablea oldtablea make new tablea with correct owner (no indexes yet) insert into tablea select * from oldtablea create indexes drop oldtablea

↪ replying to S. Radtke

rdavis@rmi.net — Tue, 12 Jan 1999 01:30:56 GMT — source: Informix-list mailing list archive (1991-1998)

In article <76vfuo$jlt$1@news.ppp.net>, "S. Radtke" <rt@pascal.de> wrote: > Hello, > > Can anybody tell me, how i can change the owner of a table without drop and > create the table ? > > Thanx Sven > > For security reasons, I believe you're forced to drop and rebuild. You could attempt hacking the system catalog but I would not recommend it. Bob -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

↪ replying to rdavis@rmi.net

Rob Wilson — Tue, 12 Jan 1999 09:07:35 -0600 — source: Informix-list mailing list archive (1991-1998)

On Tue, 12 Jan 1999 rdavis@rmi.net wrote: > In article <76vfuo$jlt$1@news.ppp.net>, > "S. Radtke" <rt@pascal.de> wrote: > > Hello, > > > > Can anybody tell me, how i can change the owner of a table without drop and > > create the table ? > > > > Thanx Sven > > > > > > For security reasons, I believe you're forced to drop and rebuild. > You could attempt hacking the system catalog but I would not recommend it. > > Bob > > -----------== Posted via Deja News, The Discussion Network ==---------- > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own > > Not a good idea to hack the system catalog, table owners are also stored in the system reserve pages (things might look corrupt). Rob Wilson rwilson@informix.com

↪ replying to rdavis@rmi.net

John Kersten — Tue, 12 Jan 1999 20:48:58 -0800 — source: Informix-list mailing list archive (1991-1998)

rdavis@rmi.net wrote: > > In article <76vfuo$jlt$1@news.ppp.net>, > "S. Radtke" <rt@pascal.de> wrote: > > Hello, > > > > Can anybody tell me, how i can change the owner of a table without drop and > > create the table ? > > > > Thanx Sven > > > > > > For security reasons, I believe you're forced to drop and rebuild. > You could attempt hacking the system catalog but I would not recommend it. > > Bob > > -----------== Posted via Deja News, The Discussion Network ==---------- > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own dbexport the database and change <databasename>.sql script where the owner is mentioned.