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

Reply via email to