> 18.09.2012 12:47, Tomasz Tyrakowski wrote: > >> Any chance the script mentioned here >> >> http://www.firebirdnews.org/?p=5027 >> >> (which was supposed to be shipped with FB 2.5.1) will be available soon? >> I'm experiencing problems described in this article and the script would >> be most welcome. > > IIRC, all you need is just to alter the view USERS to its new definition > that you can find here: > > http://firebird.svn.sourceforge.net/viewvc/firebird/firebird/branches/B2_5_Release/src/dbs/security.sql?revision=57144&content-type=text%2Fplain
The only difference between the view in 2.1 and 2.5 is the additional part in the WHERE clause: OR CURRENT_ROLE = 'RDB$ADMIN' which makes sense for Tomasz error message initially described in firebird-support. Tomasz, use ALTER VIEW and not RECREATE VIEW, because ALTER VIEW preserves SQL privileges. Regards, Thomas ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel