Product: Aqua Data Studio
Version: 15.0.0-dev-94
Database Version : Redshift
Connect Redshift:-
step-1
Create View
CREATE VIEW "testredshift"."view6"
AS
SELECT tab1.col1, tab1.col2 FROM testredshift.tab1;
GO
Step-2
Go to database tree node and expand it-> Select View folder and expand it-> Select view "view6"-> Right click on it-> Select alter view option->
Alter view window is displayed-> Go to permission tab-> Select User from permission grantee type drop down list-> Check on User abhishek and tushar
(select,insert)-> Go to preview sql tab, Below grant script is generated->
CREATE OR REPLACE VIEW "testredshift"."view6"
AS
SELECT tab1.col1, tab1.col2 FROM testredshift.tab1;
GO
GRANT SELECT, INSERT ON "testredshift"."view6" TO "abhishek"
GO
GRANT SELECT, INSERT ON "testredshift"."view6" TO "tushar"
GO
Step-3
Go to database tree node and expand it-> Select View folder and expand it-> Select view "view6"-> Right click on it-> Script object to window as->
Select create option, Below create script is generate
CREATE VIEW "testredshift"."view6"
AS
SELECT tab1.col1, tab1.col2 FROM testredshift.tab1;
GO
GRANT SELECT, INSERT ON "testredshift"."view6" TO "abhishek"
GO
GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES, RULE, TRIGGER ON "testredshift"."view6" TO "dimentrix"
GO
GRANT SELECT, INSERT ON "testredshift"."view6" TO "tushar"
GO
Now you will observe that, In Grant trigger permission script is generated. As per Redshift documentation Triggers are not supported.
Redshift documentation link:-
http://docs.aws.amazon.com/redshift/latest/dg/c_unsupported-postgresql-features.html
trigger no longer supported in gui