Difference between revisions of "GRANT"

Revision as of 13:36, 28 April 2022

SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER, CREATE, CONNECT, TEMPORARY, EXECUTE, USAGE

GRANT USAGE

GRANT USAGE ON ALL SEQUENCES IN SCHEMA your_schema TO mygrp; ^[1]

GRANT your_defined_role TO your_username;

Output:

 GRANT ROLE

SELECT * FROM your_table_name;
ERROR: permission denied for table your_table_name

GRANT SELECT ON mytable TO xxx

Amazon Redshift system information functions:

@@ Line 11: / Line 11: @@
   GRANT [[your_defined_role]] TO your_username;
- [[GRANT ROLE]]
+Output:
+  [[GRANT ROLE]]
   SELECT * FROM your_table_name;