til.duyet.net
Search…
Redshift - GRANT
Grant all on schema to user_name:
1
GRANT ALL
2
ON SCHEMA schema_name
3
TO user_name;
4
​
5
​
6
GRANT ALL PRIVILEGES
7
ON ALL TABLES IN SCHEMA schema_name
8
TO user_name;
Copied!
​
1
-- Grant Usage permission to Read-Only Group to specific Schema
2
GRANT USAGE ON SCHEMA "ro_schema" TO GROUP ro_group;
3
​
4
-- Grant Select permission to Read-Only Group to specific Schema
5
GRANT SELECT ON ALL TABLES IN SCHEMA "ro_schema" TO GROUP ro_group;
Copied!
Change owner:
1
ALTER TABLE
2
<schema>.<table> OWNER TO <user>;
Copied!
​
Copy link
Edit on GitHub