× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
chandradipjain(*) reported 2014-02-24T07:16:03Z  · tariqrahiman last modified 2014-04-30T20:47:06Z

Grant Schema Privileges pane is not provided in Alter Users/Roles


Priority Low
Complexity Unknown
Component DB - Vertica
Version 15.0
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.
1 attachment

Issue #11760

Closed
Fixed
Resolved 2014-03-05T23:38:57Z
 
 
Completion
No due date
Fixed Build v15.0.0-dev-144
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017