This much is documented in the Guide to SQL Reference manual. Mode "R" functions behave like mode "O" procedures and execute with their owner's permissions rather than the user's permissions.
Modes of "R", & "r" indicate a restricted procedure (upper case is also a DBA procedure). > select * from sysprocedures where procname = 'is_pattern_arg' Dbschema won't list it and neither will myschema. That is a built-in "protected" procedure. Not any kind of showstopper, just something I came across today when a developer complained. Or could that be because the SPL is a function and not a procedure, thus rendering the results reported by dbschema as precisely correct, but in direct opposition to the traditional way Informix has treated user routines? No procedure that correct? The SPL actually does exist and returns a value, but dbschema reports it as "No procedure". 'dbschema -d -f is_pattern_arg ' returns the -d acoms_dev -f is_pattern_argĭBSCHEMA Schema Utility INFORMIX-SQL Version 12.10.FC14
Grant execute on function 'informix'.is_pattern_arg(varchar,char) to 'public' Permissions for routine "is_pattern_arg" The following SPL exists in an Informix database:ĬREATE PROCEDURE informix.is_pattern_arg(str1 varchar(255), options char(4000)) RETURNING INTEGER
0 kommentar(er)
