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

Thank you very much sir. Very helpful. Really appreciate it. On Fri, Mar 6, 2009 at 12:16 PM, Jack Parker <jack.parker4@verizon.net> wrote: > 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 > >