Re: User privilege

spal@watson.den.csci.csc.com (Sujit Pal) wrote: :Pralay : :Row level access cannot be granted to users directly, but here is an = :approach using views which works for **most** cases: : :- Create the table. :- Create views based on the selection criterion. You mention data based = :priviledges, so I assume you must have a selection criterion. :- Revoke all permissions from public for the table. :- Revoke all permissions from public for the views. :- Grant all permissions to the first user for the first view. :- Grant all permissions to the second user for the second view. :- and so on for each user and view. : :Since these are single table views we would be able to SELECT, UPDATE, = :DELETE and INSERT into this view. The only problem you might encounter = :is when the user inadverdently does an UPDATE that moves a data element = :from one view to another. There is a "with check" (or something like that) option when you define the view so users can't update a row so it would move from one view to the other. Then they also can't insert a row that would go into the wrong view. :I dont know of any other problems. Other knowledgeable Informix-ers may = :be able to shed more light. : :HTH : :Sujit Pal : :---------- :From: Pralay Dutta Gupta[SMTP:sinfo@univ-paris8.fr] :Sent: Tuesday, February 18, 1997 9:11 AM :To: informix-list@rmy.emory.edu :Subject: User privilege : :Hi informixers! : :Does anybody know whether it's possible to grant data based=20 :privileges to users of On-line 7.10 UD1 ( isql version 6.02 UC1 ) ? : :To be more explicit, let me say, I've got two groups of users; both :using the same tables. Now, I want to grant privileges to one group :only on the data which they're in charge of. In other words, I would :like to grant row level privileges.=20 : :If you've got the answer, I'd be grateful to know. : :Thanks in advance. : :Pralay Dutta Gupta :Service Informatique :Universite Paris 8 : :sinfo@univ-paris8.fr : :--------------------------------------------------------------- :Cet article a ete poste via ( (EchO!) ) - http://echo.fr/News : : : Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org