Aqua Data Studio 15.0.0-dev-63
Build #: 35415
Built on: 2014-Jan-03 09:09:58 AM
Operating Environment: Windows7 64-bit
Database: Greenplum 4.2
Issue : In Table properties grant permissions are not displayed for user.
Steps to reproduce:
1.Run following scripts on query analyser
//Create User (with blank spaces)
CREATE USER " " WITH SYSID 29246 PASSWORD '<password>'
CREATEDB
CREATEUSER
GO
//Create Table
CREATE TABLE "public"."ash" (
"a" varchar(250) NOT NULL,
"b" varchar(250) NULL,
"c" varchar(250) NOT NULL,
"d" varchar(250) NOT NULL,
"a1" varchar(250) NULL,
"gf" timetz NULL,
PRIMARY KEY("a")
)
DISTRIBUTED BY ("a")
GO
2.Go to Schema Browser
Expand Database node
Expand desired Database
Select table “ash”, right click on table “ash”
Select Alter table, Alter table window will open then Navigate to Permissions tab
In Permissions Tab, Select Users from Permission For Grantee Type drop down list.
Now give all permissions to user “ ” and click on Alter.
3.Now go to Table “ash”, right click on table “ash”, select Table Properties option
Table Properties window opens, navigate to Permissions tab,
Grant permission are not displayed for user “ ”
Issue #11293 |
Closed |
Completion |
No due date |
No fixed build |
No time estimate |