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


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@xxxxxxxx
[mailto:informix-list-bounces@xxxxxxxx]On Behalf Of Fernando Nunes
Sent: Friday, March 06, 2009 1:41 PM
To: informix-list@xxxxxxxx
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@xxxxxxxxx>
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@xxxxxxxx
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@xxxxxxxx
http://www.iiug.org/mailman/listinfo/informix-list

.

Relevant Pages

  • Re: user permissions in a database as a whole or tables
    ... like PDF better but that was not helping this time either. ... user permissions in a database as a whole or tables ... The way to give permissions to a user is a simple GRANT. ...
    (comp.databases.informix)
  • Re: SQL Server 2005 Stored Procedure security annoyances
    ... stored proecedure on a database wide level? ... GRANT EXECUTE ON SCHEMA::MySchema TO MyRole ... I am sure I will forget some SP's and probably forget to set the rights ... permissions because not all stored procedures are equal. ...
    (microsoft.public.sqlserver.security)
  • Re: Relation of OS user to Informix database user
    ... I created two operating system users, say A and B, gave both GRANT CONNECT and GRANT RESOURCE permissions from the informix DBA user. ... When you created the database, was a MODE ANSI database, or a logged or an unlogged database. ... REVOKE SELECT ON TABLE T FROM B. This gave an error saying no record in ISAM and Unable to revoke permissions. ...
    (comp.databases.informix)
  • Re: Oracle permissions issue Oracle 9.2.0.7/Win 2003
    ... We are being dinged for grants that any schema owner is ... giving on its objects to database roles. ... SYSTEM user or a user with DBA privileges should grant the permissions ...
    (comp.databases.oracle.server)
  • Re: List Users Permissions down to table.column action
    ... THIS STORED PROCEDURE GENERATES COMMANDS ... -- FIXED PROBLEMS WITH STATEMENT LEVEL PERMISSIONS GRANTING. ... -- CREATE TABLE TO HOLD LIST OF USERS IN CURRENT DATABASE ... -- GRANT USER ACCESS TO SERVER ROLES ...
    (microsoft.public.sqlserver.security)