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

On Tue, 28 Jul 1998, Judy Mace wrote: > 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. As Informix, you can say: grant [permission] on [tablename] to [newownername] as [oldtableownername] That way you don't need to log in as the owner, also you can use the set session authorisation command, as in 'set session authorization to 'tableowner', this gives you owner rights. John