Aqua Data Studio 15.0.0-dev-124
Build #: 36233
Built on: 2014-Feb-20 04:00:40 PM
OS Environment: Windows 8(x64 bit)
Database: Vertica 7.x
Steps to reproduce:
1. Connect to Vertica server,Go to Security node
2. Create Role and User
CREATE USER "user12"
RESOURCE POOL general
IDENTIFIED BY 'md5b237b00c00bf69f5b2bb3ef47ab311ad'
ACCOUNT UNLOCK
PROFILE default
MEMORYCAP NONE
RUNTIMECAP NONE
TEMPSPACECAP NONE
GO
GRANT role5 TO user12 WITH ADMIN OPTION
GO
CREATE ROLE "role13"
GO
GRANT role4 TO role13
GO
3. Select and right click on above created user or role, Select Alter User/Role option
4. Here we observe that UI for grant Schema Previleges pane is not provided.
5. Open Query analyzer window and execute below script to grant previlege Create on schema to user
GRANT CREATE ON SCHEMA "testvertica" TO "user12"
GO
Please see attached screenshot.
This is how vertica was intially implemented. As of vertica 6.x the following are not supported
Extraction and scripting of SCHEMA grants has been added but no GUI to support.