Re: Dropping a Table

Posted in 1992

Dave Snyder — Sat, 13 Jun 92 10:05:46 EDT — source: Informix-list mailing list archive (1991-1998)

Quoting Doimic01@saad-emh1.ARMY.MIL... > In X-Informix-List-Id: <list.1235>, John Baker writes: > >In X-Informix-List-Id: <list.1231>, Nick Rumble writes: > >> Without giving RESOURCE or DBA privileges to all users, how can I > >> enable users who do *not* own the table, to drop it. > >In my understanding of data base design, something is amiss here. Why are > >you dropping the table when all you need to do is run the DELETE statement > >on it? > Yes, the DELETE statement is the logical, front-door way to do it. > But here's a sneaky backdoor way to accomplish the task: > UPDATE systables SET owner = USER > WHERE tabname MATCHES my_tab_name> Run this just before the DROP TABLE statement. This will cause problems in versions of Informix Products at 4.00 or higher. Pre 4.00 versions allowed DBA's to update the system catalogs. The new versions only allow "informix" to update the system catalogs. DAS -- David A. Snyder @ Snide Inc. - Folcroft, PA Current Release is db4glgen-3.6 UUCP: ..!uunet!das13!dave INTERNET: dave.snyder@snide.com