03.01.2012 18:53, Vlad Khorsun wrote: > If we speak about statements that issued by UDR - certainly.
I was speaking only about statements issued by UDR, as it was the subject initiated by Dimitry Sibiryakov. > 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. I don't have any preference, but I would insist on having the same behaviour for PSQL and external routines. So, unless we're going to change the legacy behaviour, the default option should be (a). I don't mind having (b) available optionally, via an explicit clause. Dmitry ------------------------------------------------------------------------------ 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