Re: Restricted access to data in remote database

Posted in 2004

Richard Spitz — Mon, 16 Feb 2004 09:38:51 +0100 — source: Usenet: comp.databases.informix

malc_p@btinternet.com (Malc P) wrote: >You could just allow selects on the column in question with >"GRANT SELECT(employee_id, begin_date, c_status) ON contract TO ><xyz>". If I granted these privileges, the users could query the table directly and retrieve information about contract duration of other employees. With the stored procedure, getting this info would be more difficult and very cumbersome, but not totally impossible. I am aware of that, but it would still offer more protection of this information than opening the table for direct queries. Regards, Richard -- +-------------------------------+-------------------------------+ | Dr. med Richard Spitz | Tel : +49-89-7095-6110 | | Klinik f'r Anaesthesiologie | FAX : +49-89-7095-6420 | | Klinikum der Univ. M'nchen | Page: +49-89-7095-789-2116 | | 81366 M'nchen, Germany | | +-------------------------------+-------------------------------+