#14753: In Netezza 7.1, "Permissions" given to Tables or Views are not reflecting either in option "Choose Script to Window-> CREATE(Full) or GRANT" or "Table Properties" and "View Properties"

pbsonaikar(*) reported 2016-10-01T14:23:16Z · last modified 2018-03-08T23:27:13Z

In Netezza 7.1, "Permissions" given to Tables or Views are not reflecting either in option "Choose Script to Window-> CREATE(Full) or GRANT" or "Table Properties" and "View Properties"

Dev	tomconrad
QA	nhilam

Priority	Low
Complexity	Unknown

Component	DB - Netezza
Version	Future

Product: Aqua Data Studio

Version: 18.0.0-devi-249

Build #: 51328

Build Date: 2016-Sep-30 07:38:38 PM

Operating Environment: Windows 7 (6.1, x86) / Cp1252 / en / IN / Oracle Corporation 1.8.0_101-b13

Memory: Max=766,312,448; Total=235,442,176; Free=55,258,792; CPUs=8

Connect to DB Netezza version 7.1

Scripts:

1. Create table

CREATE TABLE "table_company" (

"id" INT1 NOT NULL,

"e_name" VARCHAR(50) NULL,

"departments" NVARCHAR(200) NULL,

"profit" FLOAT4 NULL,

CONSTRAINT "PK03" PRIMARY KEY("id") DEFERRABLE INITIALLY IMMEDIATE

) DISTRIBUTE ON ("id")

GO

ALTER TABLE "table_company"

ADD CONSTRAINT "UK03"

UNIQUE ("departments") DEFERRABLE INITIALLY DEFERRED

GO

2. Add some "Permissions to the table"

GRANT ALL ON "ADMIN"."table_company" TO "parikshit"

GO

GRANT ALL ON "ADMIN"."table_company" TO "ADMIN"

GO

Steps:

1. After creating the table, added permissions like mentioned above.

2. Command get executed successfully.

3. Go to Table tree node-> select option "Choose Object to New Window-> CREATE(Full)"

4. "Create table" script generated on "Query Analyser" successfully.

5. But GRANT script and REVOKE script not get generated.

6. Go to Table Properties of the above-mentioned table, go to "Permissions" tab, you'll see no change.

Actual Result:

After executing commands of Permission regarding table, views or Procedures, command gets executed successfully but they don't reflect on any of the objects either on "Table or View Properties" or by an option "Choose Script to Window".

Neither "Table" or "View" Properties nor option "Choose Script to Window-> CREATE(Full) or GRANT" shows changed permissions of the object.

Expected Result:

After "Altering" permissions, it should reflect on that specific Table or View either in "CREATE(Full)" script or in "Table Properties or View Properties".

Observation:

As commands of Permission get executed on Query analyser as well as through UI, changes get applied on certain Table or View but nodes they're failing to reflect it.

Build Information:

I checked this behaviour for 3 different DBs.

1. Netezza version 7.1

BEHAVIOUR	Database
	Netezza version 7.1
	WINDOWS
ADS Version 18 build – 249	N
ADS Version 17	N
ADS Version 16	N
ADS Version 15	N
ADS Version 14	N
Y- Yes, we can see permissions in GRANT script and Properties of Table or View
N- No, we can not see permissions in GRANT script and Properties of Table or View

Comments :

1. This issue occurs for version 7.1 and ADS-v18, ADS-v17, ADSv-16, ADS-v15, ADS-v14.

2. This issue occurs on "WINDOWS".

Note : Unable to check other OS because DB is running locally and no other version is available.

2. DB PostGrey version 9.5

BEHAVIOUR	Database
	PosteGrey version 9.5
	WINDOWS	LINUX
ADS Version 18 build – 249	Y	Y
ADS Version 17	Y	Y
ADS Version 16	Y	Y
ADS Version 15	Y	Y
ADS Version 14	Y	Y
Y- Yes, we can see permissions in GRANT script and Properties of Table or View
N- No, we can not see permissions in GRANT script and Properties of Table or View

Comment :

No issue occurred for version 9.5 and ADS-v18, ADS-v17, ADSv-16, ADS-v15, ADS-v14 for both OS.

3. GreenPlum

BEHAVIOUR	Database
	GreenPlum version 4.3.9.1
	WINDOWS	LINUX
ADS Version 18 build – 249	Y	Y
ADS Version 17	Y	Y
ADS Version 16	Y	Y
ADS Version 15	Y	Y
ADS Version 14	Y	Y
Y- Yes, we can see permissions in GRANT script and Properties of Table or View
N- No, we can not see permissions in GRANT script and Properties of Table or View

Comment :

No issue occurred for version 4.3.9.1 and ADS-v18, ADS-v17, ADSv-16, ADS-v15, ADS-v14 for both OS.

2 attachments

view_behaviour.png

2016-10-01T14:23:16Z

125 KB
table_behaviour.png

2016-10-01T14:23:16Z

160 KB

All Comments (0) Change History

Search Tips

Aqua Data Studio / nhilam

In Netezza 7.1, "Permissions" given to Tables or Views are not reflecting either in option "Choose Script to Window-> CREATE(Full) or GRANT" or "Table Properties" and "View Properties"

2 attachments

Issue #14753

Completion

Search Tips

Aqua Data Studio / nhilam

Title

In Netezza 7.1, "Permissions" given to Tables or Views are not reflecting either in option "Choose Script to Window-> CREATE(Full) or GRANT" or "Table Properties" and "View Properties"

2 attachments

Issue #14753

Completion