Aqua Data Studio 15.0.0-dev-96
Build #: 35893
Built on: 2014-Feb-06 02:45:16 PM
Database : Vertica 7.0
OS: Windows 8,64 bit
Steps to Reproduce:
1] Connect to vertica 7.0 server
Right click on vertica server and select option "Query Analyzer"
2] Query Analyzer window opened successfully.
Create Profile (Run following script)
CREATE PROFILE MyProfile LIMIT
PASSWORD_LIFE_TIME UNLIMITED
PASSWORD_GRACE_TIME UNLIMITED
FAILED_LOGIN_ATTEMPTS UNLIMITED
PASSWORD_LOCK_TIME 4
PASSWORD_REUSE_MAX 3
PASSWORD_REUSE_TIME 6
PASSWORD_MAX_LENGTH 8
PASSWORD_MIN_LENGTH 1
PASSWORD_MIN_LETTERS 4
PASSWORD_MIN_UPPERCASE_LETTERS 2
PASSWORD_MIN_LOWERCASE_LETTERS 3
PASSWORD_MIN_DIGITS 3
3] Now go to "Security" in server tree node and expand it.
Go to "Profiles" and expand it.
Here in Profiles node we can observed created profile i.e MyProfile
4] So when we right click on "Profiles", CREATE PROFILE option is not provided.
Also we can ALTER and DROP the profiles from Query Analyzer
[Please see attached image]
extraction / scripting / GUI added. Menu items added.