Re: HELP!!! UNIX groups and Informix roles driving me nuts!!!

Unix groups and informix roles are completely different. You could have the same names for the Unix groups and Informix roles, but you cannot inherit the Unix level privileges for that user_id and group into Informix in any way. Now, once you add an user to a group, that user will not automatically inherit the role level priveleges until he runs the SET ROLE statement. By default all users get the role PUBLIC. After you run the set role, the role's priveleges are active for the rest of the session. Hope that helps, Arun edi_man@my-dejanews.com wrote: > We are running Informix 7.24 and are trying to create groups (or roles) in > Informix which will filter the DB permissions to UNIX users whose UNIX group > is the same as the Informix role. I need to know a couple of things: 1. Is > there a difference between roles and groups in Informix? 2. Is what we are > attempting even possible? We have a DB with at least 50 tables and should be > able to split the DB access level permissions among 4 different groups, but > it's not working. For example, I am a member of the group admin, which > should have select,insert,update,delete on all tables. However, when I log > in with the application, these permissions do not filter through based on my > group membership. PLEASE HELP ME!!!! > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- > http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum