Aqua Data Studio 15.0.0-dev-82
Build #: 35685
Built on: 2014-Jan-24 05:27:23 PM
O.S. : Windows 8.1(64 bit)
Database : Netezza 7.0.3
Issue: Table list and permissions given on tables are not displayed in Groups.
Steps to Reproduced:
1]Connect to netezza server,Expand Databases tree node.
2]Expand any Database, Expand Tables tree node.
3]Right click on any table(Here i have selected "table_hospital" table) and select Alter Table option.
4]Alter table window opens, Switch to Permissions tab.
5]Select "Groups" from "Permissions for Grantee Type" drop down list.
6]Grant permissions to Groups(Here i have gave permissions to "chck_grp" ans some other Group)
7]Click on Alter.
Now in server tree node,Expand security tree node.
1]Expand Groups tree node.
2]Right click on any existing group and select Alter group option(Here i have selected "chck_grp" Group).
3]Alter Group window opened, Click on "Object Permissions" button.
4]Select "Tables" option from "Permissions for objects" drop down list, Select option "ALL" from "in Schema" drop down list.
Actual Result : Tables list is not displayed.
Expected Result : Tables list should be display with all granted permissions.
This was fixed already. The server security nodes will no longer contain object information for clustered DBs as we would have to make a different connection for each database and query each database for its info for each security group/user. Instead users/groups have been added at the database level and here is where you can access the object permissions info.