Re: Informix 7.12: Stored Procs vs Roles

tov@inist.ru (Oleg Tretyakov) wrote: :Hi Nils, :You are not quite right. Stored procedures is powerful feature to :control access to database. You can restict any access to the database :tables but users can view and modify data through stored procedures. :Of course everyone who have privilege can execute procedure through :ODBC. But it is legal usage of stored procedures. All direct :modifications data in tables may be forbidden. Well, it may be legal usage of stored procedures. The problem is that we want to restrict some users, or rather users using non approved applications, from any updates of the database, directly or through stored procedures. There are many good reasons for wanting to do that. :Regards :Oleg Tretyakov :tov@inist.ru 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