On 01/03/12 18:53, Vlad Khorsun wrote: >> 03.01.2012 18:06, Vlad Khorsun wrote: >>> Who will be the CALLER if UDR function is used in SELECT statement issued by >>> client ? >> CALLER is UDR itself, so this question is meaningless for me, sorry. > If we speak about statements that issued by UDR - certainly. But if we > speak about > UDR itself - what set of privileges should it have ? So far there are two > propositions: > a) explicit grant privileges to UDR (same as P-SQL objects) > b) allow UDR to inherit privileges of creator\owner user > BTW, second options is the only way in MSSQL even when work with TSQL objects. > BTW2, both features could co-exists. > > We should decide if we need one of them, or both, or something else...
Ideally we need both of them, and not for external objects only, but for P-SQL objects too. ------------------------------------------------------------------------------ Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join http://p.sf.net/sfu/intel-appdev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
