Re: granting select only priviledges

Posted in 1998

FProse — Tue, 8 Dec 1998 07:53:57 -0700 — source: Informix-list mailing list archive (1991-1998)

I won't comment on your last statement... When I needed to do something similar I constructed a script using systables.tabname similar to: select "grant ... on ", tabname, " to ...;" from systables where tabid > 100; The other option is to "select" out the tablenames and then use an editor to build your script.