Re: Run 4GL Program without Database Permissions?

Posted in 1996

Richard Spitz — 5 Sep 1996 10:27:04 GMT — source: Informix-list mailing list archive (1991-1998)

Steven Hauser (hause011@maroon.tc.umn.edu) wrote: : How about a stored procedure owned by a user that has the rights to the : 2nd database, the procedure can be called by any user on the first database : and executes with the rights of the procedure owner. Yes, but to execute the procedure, a user still needs CONNECT privilege for the 2nd database. I want to avoid having to grant (and administrate) any privileges for the 2nd database to the users of the 1st. Regards, Richard -- +----------------------------+-------------------------------------------+ | Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-3413 | | Klinikum Grosshadern | FAX : +49-89-7095-8886 | | 81366 Munich, Germany | | +----------------------------+-------------------------------------------+