× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
chandradipjain(*) reported 2014-02-19T09:32:23Z  · SachinPrakash last modified 2014-02-20T00:35:54Z

Can we have 'Grant All' option in permission tab of Alter Table/View window for Amazon Redshift


Priority Low
Complexity Unknown
Component App - Visual Editing
Version Future - .1
Aqua Data Studio 15.0.0-dev-114 
Build #: 36113 
Built on: 2014-Feb-16 07:56:20 AM
OS Environment: Windows 8(64 bit)
Database: Amazon Redshift
 
Steps to reproduce:
1. Connect to Amazon Redshift Server,Go to databases
2. Go to Tables folder node, Select any table and right click on it and Select Alter Table option
3. In Alter Table window switch to permissions tab, there 'ALL' option for Users or Group is not provided.
4. We can Grant All permission (Select,Insert,Update,Delete,Reference) to user or Group on object by using 'ALL' keyword in Sql command 
 
   Sql Command :
   GRANT ALL ON "testredshift"."TAB1" TO "user2"
   GO
   
5. If we execute above command all permissions are granted to user2 on TAB1 table object.
6. We can add this option for view also.
 
Please see attached screenshot.
1 attachment

Issue #11732

Closed
 
 
Completion
No due date
No fixed build
No time estimate

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