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;
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 4: / Line 4: @@
 * <code>[[GRANT ALL PRIVILEGES]] ON DATABASE YOUR_DB_NAME TO YOUR_USERNAME;</code>
-  [[SELECT]]
+  [[SELECT]], INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER, CREATE, CONNECT, TEMPORARY, EXECUTE, [[USAGE]]
- INSERT
- UPDATE
- DELETE
- TRUNCATE
- REFERENCES
- TRIGGER
- CREATE
- CONNECT
- TEMPORARY
- EXECUTE
- [[USAGE]]
   [[GRANT USAGE]]
@@ Line 24: / Line 11: @@
   GRANT [[your_defined_role]] TO your_username;
-  GRANT ROLE
+  [[GRANT ROLE]]
   SELECT * FROM your_table_name;