user permissions in a database as a whole or tables
Posted in 2009
Hello again, I have IDS 9.40 running over RedHat. I have quite a few databases in there. I have created a new user in linux and need to have it as database administrator in one database (it already has one but I need a second) and in another database the same user needs to have SELECT, INSERT, UPDATE etc permissions in only a number of tables and views. Is there any documentation that can show me how to set permissions in Informix? I looked at Administrator's Guide, Reference for IDS 9.40 but couldn't find anything. I also did look at SQL Reference Guide and couldn't find anything there either. I also have Informix Server Administrator running but that even there I cannot find how I can achieve what I described above. I wouldn't mind reading a reasonable amount of documentation (up to 100 pages) about this but I cannot find any so far. Any help or direction is very much appreciated. Thank you, Genti