At 11:42 p.m. 27/02/2014, Alex Peshkoff wrote: >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.
Oh, OK, of course. I had overlooked that. ;-) Helen ------------------------------------------------------------------------------ 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
