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

That is exactly how I feel when I look at the information center. I like PDF better but that was not helping this time either. I find myself sometimes that all I need is just a little bit of directon (talking about Informix) - the rest I can discover by myself. Thank you guys, On Fri, Mar 6, 2009 at 2:02 PM, Jack Parker <jack.parker4@verizon.net> wrote: > > The information center is a blight on the syrface of the web.  It takes you > to these lovely organized html pages which are geared towards providing a > single snippet of information totally devoid of context.  Trying to research > a topic through that is akin to trying herd cats - you have to know what > snippet of information you are after, which thread to follow.  I have > handled more complaints coming from people trying to find information via > that monstrosity - I always direct people to the PDFs.  Better to "waste" > time reading the entire topic and discover the vital ancillary information > than try to re-assemble that knowledge out of the information center. > > 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 Fernando Nunes > Sent: Friday, March 06, 2009 1:41 PM > To: informix-list@iiug.org > Subject: Re: user permissions in a database as a whole or tables > > > Gentian Hila wrote: >> No you did not miss the point. It's just that I have never done it and >> couldn't find any direction so far. >> >> Hope it wasn't a very stupid question!  But I asked because I do not >> know it. That is why. >> >> >> >> Thanks, >> >> >> >> On Fri, Mar 6, 2009 at 12:12 PM, Fernando Nunes <domusonline@gmail.com> > wrote: >>> Gentian Hila wrote: >>>> 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 >>> I'm not sure what you're rally asking. >>> The way to give permissions to a user is a simple GRANT. There is > information >>> about it in the Syntax Guide and I assure you it's well under 100 pages. >>> >>> Something like: >>> >>> DATABASE the_db_where_user_should_have_DBA; >>> GRANT DBA TO user;>>> >>> DATABASE the_db_where_it_should_have_some_table_permissions; >>> GRANT CONNECT TO user;>>> GRANT ... ON table1 TO user; >>> GRANT ... ON table2 TO user; >>> ... >>> >>> So... nothing special... And obviously documented... >>> If I missed the point please clarify. >>> Regards. >>> >>> >>> -- >>> Fernando Nunes >>> Portugal >>> >>> http://informix-technology.blogspot.com >>> My email works... but I don't check it frequently... >>> _______________________________________________ >>> Informix-list mailing list >>> Informix-list@iiug.org >>> http://www.iiug.org/mailman/listinfo/informix-list >>> > > No. It's not a stupid question. I was just surprised you didn't find it in > the > manual. But the fact is, the manual is organized more "alphabetic" then by > subjects (the PDF). > Checking the Information Center, provided by another poster, what you should > search for is something like "table privileges" or "database privileges". > This leads to the information you require. That's why the information center > is > so useful. Of course, once you know what you need the SQL syntax guide in > PDF > is quicker... > > Regards. > > -- > Fernando Nunes > Portugal > > http://informix-technology.blogspot.com > My email works... but I don't check it frequently... > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >