Привет, народ помогите кто чем может.

DBA не может выпонить запрос к таблице в другой базе данных из процедуры ???
А resource может :(

Пример кода.
create database test1;
grant resource to user1;
grant resource to user2;

create database test2;
grant resource to user1;
grant resource to user2;

database test1;
set session authorization to "user1";
create table "user1".t1 (id int);
grant all on "user1".t1 to "user2" as "user1";
grant all on "user1".t1 to "informix" as "user1";

select *
from systabauth a, systables b
where a.tabid= b.tabid
and b.tabname = 't1';
-- grantor grantee tabid tabauth tabname owner ....
-- user1 informix 100 su-idxar- t1 user1 ....
-- user1 user2 100 su-idxar- t1 user1 ....

insert into "user1".t1 values (1);

database test2;
set session authorization to "user2";

create procedure "user2".proctest()
define v_id int;
foreach select id
into v_id
from test1:"user1".t1
end foreach;
end procedure;

set session authorization to "informix";
select id from test1:"user1".t1;
execute procedure "user2".proctest();
-- [Informix][Dynamic Server plus Universal Data Option][test2]
-- SQL Error (-272) : No SELECT permission.