Granting privileges to a group of users
Greetings,
Using Informix-SE, I know it is possible to grant table and
database privileges to a user or a comma separated list of users. I
would like to know if it is possible to grant privileges to a group
of users ala UNIX's /etc/group.
Suppose group "clerk" contains "mary, sue, joe, fred" and group
"manager" contains "larry, curly, moe." It sure would make administration
easy if you could say:
grant select on employee to clerk;
grant insert, delete, update on employee to manager;
When more people were added to a group, you wouldn't have to remember to
grant privileges.
Other than writing some ESQL/C routines, can this be done with
Standard Engine? Please, no 4GL solutions since I don't have it. My
environment:
386 running AT&T UNIX SVR3.2.3
Informix SE Version 4.00.UH1
Informix ESQL/C Version 4.00
As always, any help is appreciated.
---
Chris Hardin chris@green.att.com ...!att!green!chris 404.750.5246