Re: Dropping tables...

Posted in 1995

Billy Wheeler — 11 Dec 1995 01:28:05 -0500 — source: Informix-list mailing list archive (1991-1998)

>geigerk@cairns.UUCP ( Development) wrote: >>There appears to be a limitation in informix that only the owner of a table [SNIP] > >Try this: grant all on <table-name> to public; > >This will give full access (including dropping) to any user. I'm not sure if this is true - I think you have to GRANT DBA TO user to allow them to DROP TABLEs. But I haven't got a manual handy to confirm this... :-) HTH. -- Cheers, Billy "Have you got it yet?" (c) Dazza, 1995