Re: Dropping tables...

geigerk@cairns.UUCP ( Development) wrote: >There appears to be a limitation in informix that only the owner of a table >can drop that table. Is there any way to get around this limitation? Can >you create a table that anyone can drop? I have a situation where I need to >create temporary tables which last longer than the program and which are >accessable by all users, but which can be deleted by any user. > >If you have an idea, drop me an e-mail at KimGeiger@aol.com or post the message >here. > >Thanks. Try this: grant all on <table-name> to public; This will give full access (including dropping) to any user. Good Luck