Restricted access to data in remote database
Hi Informixers,
since there was not a single reply to my last posting about
my problem, I'll try again and rephrase my description.
I need to give certain users access to some information from
a table to which they have no select (or any other) permission.
This is the table definition:
CREATE TABLE contract (
employee_id integer,
position_id integer,
begin_date date,
end_date date,
c_status char(4)
);
These are sensitive data, hence the requirement to not
give any permissions on this table to the users in
question. However, they need a certain piece of info
from this table: For a given employee_id and date,
retrieve c_status.
For added complexity, the users are connected to
another database on another instance of the engine.
They do have connect permission to the database
and select permission on some other tables.
I know how to write a Stored Procedure that retrieves
the information I need. What I don't know is how I can
let my users call this procedure "remotely" from the
other database they are connected to.
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 | |
+-------------------------------+-------------------------------+