Aqua Data Studio 15.0.0-dev-118
Build #: 36162
Built on: 2014-Feb-18 03:37:32 PM
OS Environment: Windows 8 (x64 bit)
Database: Amazon Redshift
"java.lang.ArrayIndexOutOfBoundsException" in preview tab of Alter User window.
Steps to reproduce:
1. Connect to Amazon Redshift server,Go to any database
2. Create User in selected database
CREATE USER "user1" WITH PASSWORD '<password>'
VALID UNTIL '2014-02-28 00:00:00+00'
CREATEDB
NOCREATEUSER
/
GRANT CREATE, TEMP ON DATABASE "test" TO "user1"
/
3. Select and right click on above created User,Select Alter User option
4. In Alter User window Click on Object Permission button
5. In Alter User : Object permission window Select Tables/Views from Permissions for object dropdown list and Select Schema from dropdown list
6. Tables are listed in Object pane, Check select,insert permission checkbox for any table
7. Now switch to Preview Sql tab, Here we observe that it throws ArrayIndexOutofBounds Exception when we Grant any permission to user on any object.
8. In View Log window also it gives ArrayIndexOutofBounds Exception.
Please see attached screenshot.
Same issue reproduced with Groups also.