On 12/15/13 05:27, Adriano dos Santos Fernandes wrote: > Hi! > > Syntax for attributes for users (CORE-4290) is not good IMO. > > Current: > > create user x password 'y' [set] a [to] 'a', b [to] 'b'; > > alter user x [set] a [to] 'a', b [to] 'b'; > > alter user x drop a, b; > > In think syntax below is better: > > create user x password 'y' set a = 'a', b = 'b'; > > alter user x set a = 'a', b = 'b'; > > alter user x drop a, b; > > i.e. replace optional [TO] by enforced '=' and enforce the use of SET. >
No problems. And what do you think about a case when (I use old syntax for an example): alter user x [set] password 'y' [set] a [to] 'a', b [to] 'b'; Where should that set be placed? I prefer to: alter user x password 'y' set a = 'a', b = 'b'; Is it OK? ------------------------------------------------------------------------------ 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
