Re: Increase Security

Posted in 1995

Mark Christmas — 25 Oct 1995 15:07:04 GMT — source: Informix-list mailing list archive (1991-1998)

The only solution to this problem that I am aware of is to actually store static SQL statments and the programs that contain them in the DB catalogs. Privileges are granted on these programs (eg EXECUTE). The creator of the program must have the correct authorities to run the SQL within the programs. Once completed, users don't need authorities against the tables accessed in the programs, only privileges to run the programs. But this is a DBMS implemetation issue, not one that the users of the DBMS can solve. Mark Christmas CrossKeys Systems Corp