On 02/27/14 14:19, Helen Borrie wrote: > Observation: I had to commit explicitly following the CREATE USER statement. > I guess it's really not "pure DDL" to be affected by autoddl=on...?
CREATE USER is real DDL statement and it's affected by autoddl. I suppose you did not see added user in sec$users? Yes, commit is needed, but it commits not DDL transaction. If you select from sec$ table snapshot for it is created in current transaction (same way as for mon$ tables) and to see new data you must commit transaction used by select operator. ------------------------------------------------------------------------------ Flow-based real-time traffic analytics software. Cisco certified tool. Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer Customize your own dashboards, set traffic alerts and generate reports. Network behavioral analysis & security monitoring. All-in-one tool. http://pubads.g.doubleclick.net/gampad/clk?id=126839071&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
