Hi Informixers,
I need to give access to some data in a remote database to some users
who don't have explicit select privilege on the table in question.
I had hoped that creating a dba procedure in the remote database that
does the select would achieve this, but it doesn't work, I get the
-272 error (No SELECT permission) when the procedure is called.
This is what I'm doing:
In database DB_1 on server S_1, I created the following procedure
as DBA:
create dba procedure get_status(p_nr integer, datum date)
returning char(4);define akt_status char(4);
select distinct v_status into akt_status
from vertrag
where persnr = p_nr
and datum between v_begin and v_end;return akt_status;
end procedure
grant execute on get_status to nonpriv_user;
As user "nonpriv_user" on server S_2, I'm connected to database DB_2 and
would like to execute the procedure "get_status" in DB_1. "nonpriv_user"
has connect permission on DB_1 and select permission on some tables,
but not on the table where the SP gets the data.
Granting select permission on that table should be avoided if at all
possible. How can I still let the nonprivileged user have access to
the data the SP retrieves?
Environment is IDS 7.31UD5 on Linux (SuSE 7.2).
Regards, Richard