Re: sysrowauth?

>From: Scott Ford <uunet!wvus.org!sford> >Date: Tue, 16 Mar 1993 22:52:55 -0800 (PST) >Subject: sysrowauth? >X-Informix-List-Id: <list.2024> >Of course the subject is silly - the notion of a sytem table called >"rowauth" like the existing "colauth". But it does lead to my question >-- does anyone have ideas about how to employ access limitations on >particular rows within tables without using views? Using the standard products, I don't think you can, short of using a stored procedure to control who can access what, but all programs which accessed the table would have to go through the procedure, and all other access to the table would have to prohibited (for the users to be restricted, at any rate). Using OnLine-Secure, you could stop people seeing things that they ought not to see by giving the data suitable security tags, but that is a sledgehammer to crack a nut unless you need multi-level security anyway. Yours, Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h>