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

Yes, we do have this problem and have been told by Informix in Sydney that the only way around this problem is to revoke all from public and give each user select, connect etc permission to each table. Another problem is that if you don't own the specific table you can't change the premissions, so you have to log in as each owner. I would appreciate it if someone out could advise me how to get around this situation. Judy. 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