DataBase - user permissions in a database as a whole or tables

Asked By Gentian Hila

06-Mar-09 11:58 AM

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 could not
find anything.

I also did look at SQL Reference Guide and could not 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 would not 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

06-Mar-09 12:12 PM

I am not sure what you are 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 is 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 do not check it frequently...

06-Mar-09 12:52 PM

No you did not miss the point. it is just that I have never done it and
could not find any direction so far.

Hope it was not a very stupid question!  But I asked because I do not
know it. That is why.



Thanks,

06-Mar-09 01:40 PM

No. it is not a stupid question. I was just surprised you did not 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 do not check it frequently...