Aqua Data Studio 15.0.0-dev-122
Build #: 36196
Built on: 2014-Feb-19 06:16:32 PM
OS Environment: Windows 8 (x64 bit)
Database: Vertica 7.x
Steps to reproduce:
1. Connect to vertica server,Go to security node
2. Select and right click on Users node and select Create User option
3. In Create User window, Give user name,password and check Expire Password checkbox and click on Create button
4. Select and right click on above created user,Select User Properties option
5. In User properties window we observe that Expire Password checkbox is displayed as unchecked.
6. Even when we check Expire Password checkbox in Alter User window and review it in User properties window it still shows as unchecked.
Please see attached screenshot.
This is working as designed. Expire is not a stored property. I have removed it from the view properties but it is actually used for the create and alter DDL statements.