Re: Privileges Granted by Group

This is a bit of a cheek but it works well. select "grant all on ",tabname," to fred;" from systables where tabid > 1 The result is a script file with all your 'grants' in. I am sure if you play with it a bit, you can join it with a user/group table thereby allowing for the 'fred' to be replaced. ---------------------------------------------------------------------------- Neil - storm@aztec.co.za < ANOTHER ESSEX LAD > ---------------------------------------------------------------------------- Michael G. Petersen (mgp@nwedim.ih.att.com) wrote: : Does Informix On-line have features that will allow privileges to : be granted by user group. Something like this: : 1) Have a privilege/group table (user_id and privilege_group) : 2) Grant privileges (insert, select, update, etc) on specified : tables to the group. : This way a new user (user_id) can be added to the privilege/group table : or a user can be removed from the privilege/group table. The : administrator would no longer have to find all the individual tables : that the user needs/has privileges followed by granting/revoking : privileges on all these table. : Mike Petersen mgp@nwedim.att.com (708) 224-4838 AT&T Lisle, IL : /**********************************************************************/ -- Neil - @storm@aztec.co.za < ANOTHER ESSEX LAD >