RE: user permissions in a database as a whole or tables

Try the SQL Syntax manual. Grant and Revoke are the verbs you want. These will work: http://www-01.ibm.com/software/data/informix/pubs/library/ids_100.html j. Sane ego te vocavi. Forsitan capedictum tuum desit. -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org]On Behalf Of Gentian Hila Sent: Friday, March 06, 2009 11:59 AM To: IIUG Informix List Subject: user permissions in a database as a whole or tables 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 _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list