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.
This is a feature request that could improve grant/revoke ease of use among all databases. It would require some research on how to make it work for all the databases but would be a good thing to do. Assigning to sachin for approval...