Re: Privileges Granted by Group

On Mon, 27 Feb 1995, Michael G. Petersen 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. > There isn't a feature like you described. Some of the work-arounds I have seen are: 1) write a SQL script to do that, and maintain a database of users and their respective group. Kinda troublesome, but rather flexible, usually part of a bigger system, say accounting, .... 2) a shell script that looks at the /etc/group file, and grants priviledges accordingly. The shelll script is found in an article in a back issue of Informix Tech Notes, for '93 I think, or could be '92. (PS. Is it in the FAQ??) =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Calvin Ng email: <calvinng@technet.sg> --------------------------------------------------------------------------- [DISCLAIMER] Read at your own risks. The author is not liable for any consequences directly or indirectly involved with reading this mail. This mail MAY NOT be interpreted as those of my employer's. --------------------------------------------------------------------------- This mail is sent with the help of Chameleon TCP/IP for Windows. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=