Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Redshift : Group keyword is missing for Grant/Revoke
Create a table in Amazon Redshift
Alter the table and give permission to a group. For example
SELECT, INSERT, UPDATE, DELETE, REFERENCES, RULE ON public.grant_perm TO GROUP aquafold
Now, when you script back the GRANT group keyword is missing. When you script to new window the script is as below which is incorrect.
SELECT, INSERT, UPDATE, DELETE, REFERENCES, RULE ON public.grant_perm TO aquafold
Modifications made to extraction sql to extract the grantee type for the following object types: [TABLE, VIEW, SEQUENCE, FUNCTION, SCHEMA, DATABASE & TABLESPACE].
Scripting code enhancement made to script the GROUP keyword when the grantee type is a group.
extraction and scripting will now correctly dictate GROUP type
extraction and scripting will now correctly dictate GROUP type
Verified in ADS v16.0.5-26. The redshift UI only has Tables, Views nodes and I tested for those. The rest are the postgreSQL objects which are not present on Amazon Redshift
Verified in ADS v16.0.5-26. The redshift UI only has Tables, Views nodes and I tested for those. The rest are the postgreSQL objects which are not present on Amazon Redshift
There is an exception that is occurring in the Group node. When you try to script for example the aquafold group an error is getting generated in View Log
There is an exception that is occurring in the Group node. When you try to script for example the aquafold group an error is getting generated in View Log
wrong table was been used to extract database permissions. issue was a caused when I back ported the code, accidentally copied wrong table name... correct table been used now.
wrong table was been used to extract database permissions. issue was a caused when I back ported the code, accidentally copied wrong table name... correct table been used now.
Fixed the scripting error for Group in ADS v16.0.5-27. The GROUP clause scripts correctly in Grant/Revoke and Server Script Generator
Fixed the scripting error for Group in ADS v16.0.5-27. The GROUP clause scripts correctly in Grant/Revoke and Server Script Generator
Issue #13691 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build v17.0.0-alpha-28, v16.0.5-27 |
| No time estimate |
Modifications made to extraction sql to extract the grantee type for the following object types: [TABLE, VIEW, SEQUENCE, FUNCTION, SCHEMA, DATABASE & TABLESPACE].
Scripting code enhancement made to script the GROUP keyword when the grantee type is a group.