User privilege

You can grant column level privileges to a user. Since you have an 7.x engine I would check out using "ROLES". See the Guide to 7.1 Feature Enhancements for information on "ROLES". Yet column level grants have been around for some time. See Chapter 10 in the Informix Guide to SQL Tutorial Version 7.1, page 10-11 to be specific. Hope this helps! C.L. Kendricks --------------------------( Forwarded letter 1 follows )--------------------- Date: Tuesday, 18 February 1997 2:15pm From: sinfo@univ-paris8.fr Subject: User privilege Date:Tue, 18 Feb 1997 10:11:44 -0600 Reply-To: Pralay Dutta Gupta <sinfo@univ-paris8.fr> Organization: ns.univ-paris8.fr via ( ( EchO! ) ) Sender: informix-list-owner@rmy.emory.edu To: informix-list@rmy.emory.edu X-Informix-List-Id: <news.34077> Hi informixers! Does anybody know whether it's possible to grant data based privileges to users of On-line 7.10 UD1 ( isql version 6.02 UC1 ) ? To be more explicit, let me say, I've got two groups of users; both using the same tables. Now, I want to grant privileges to one group only on the data which they're in charge of. In other words, I would like to grant row level privileges. If you've got the answer, I'd be grateful to know. Thanks in advance. Pralay Dutta Gupta Service Informatique Universite Paris 8 sinfo@univ-paris8.fr