Remote UDR call return 1: Not owner
Hello,
I have simple UDR
Cartur@marylin:/home/artur$ myschema -d bluebird@testel -f
clock_gettime_realtime
CREATE FUNCTION clock_gettime_realtime ()
returning datetime year to fraction(5)
external name '/opt/informix/udr/time.so(mi_clock_gettime_realtime)'
language C;
GRANT EXECUTE ON FUNCTION clock_gettime_realtime () TO "public";
When I call it on the server its work
Cartur@marylin:/home/artur$ echo "execute function
clock_gettime_realtime()" | dbaccess bluebird@testel
Database selected.
(expression)
2017-08-11 13:06:15.61643
1 row(s) retrieved.
Database closed.
When I call it from another Informix server
Cartur@marylin:/home/artur$ echo "execute function
bluebird@testel:clock_gettime_realtime();" | dbaccess bora@marylin
Database selected.
(expression)
1: Not owner
Error in line 1
Near character position 56
Database closed.
Another statements in SQL/SPL works normal
Cartur@marylin:/home/artur$ echo "select 'found' from
bluebird@testel:global" | dbaccess bora@marylin
Database selected.
(constant)
found
1 row(s) retrieved.
Database closed.
IBM Informix Dynamic Server Version 11.70.FC5XE on all servers
Give me good advice because I have no fresh idea :(
Best regards,
Arthur V.Sidorenko