Re: Dropping a Table

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_nameRun this just before the DROP TABLE statement. Todd Glidden CSC Inc. Sacramento Army Depot "What is the correct spelling of 'kludge/clooj/kluge', anyways?"