On 12/16/13 15:28, Mark Rotteveel wrote: > I like this, but a problem with this is: what is the behavior if an > existing attribute for the user isn't specified in an ALTER USER .. > ATTRIBUTES(...)? Will that delete the attribute, or leave it untouched?
Certainly it will remain untouched. > With the SET syntax this is better defined (although 'deleting' an > attribute isn't really possible with that syntax; and I consider > non-existence something else than being NULL). There is a DROP syntax to delete unneeded attributes: alter user x drop a, b, c; ------------------------------------------------------------------------------ Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel