Difference between revisions of "GRANT"
Jump to navigation
Jump to search
↑ https://stackoverflow.com/a/10353730
↑ https://dba.stackexchange.com/a/184339
| Line 19: | Line 19: | ||
* List roles: <code>[[\du]]</code> or <code>[[SELECT * FROM pg_roles;]]</code> | * List roles: <code>[[\du]]</code> or <code>[[SELECT * FROM pg_roles;]]</code> | ||
| − | == Amazon Redshift == | + | == [[Amazon Redshift]] == |
[[Amazon Redshift]] system information functions: | [[Amazon Redshift]] system information functions: | ||
* <code>[[HAS_TABLE_PRIVILEGE]]</code> | * <code>[[HAS_TABLE_PRIVILEGE]]</code> | ||
Revision as of 13:40, 28 April 2022
- PostgreSQL Documentation: https://www.postgresql.org/docs/current/sql-grant.html
Examples
GRANT ALL PRIVILEGES ON DATABASE YOUR_DB_NAME TO YOUR_USERNAME;
SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER, CREATE, CONNECT, TEMPORARY, EXECUTE, USAGE
GRANT SELECT ON mytable TO xxx
GRANT USAGE GRANT USAGE ON ALL SEQUENCES IN SCHEMA your_schema TO mygrp; [1]
Command: GRANT your_defined_role TO your_username;
- Output:
GRANT ROLE
SELECT * FROM your_table_name; ERROR: permission denied for table your_table_name
- List roles:
\duorSELECT * FROM pg_roles;
Amazon Redshift
Amazon Redshift system information functions:
Activities
- View GRANTs on Redshift: (
HAS_TABLE_PRIVILEGE) - Amazon Redshift: show permissions: (
has_schema_privilege) - Amazon Redshift: grant read only provileges to user
Related terms
- Amazon Redshift: GRANT
\dn+\ddp[2]CREATE ROLE- Connect to a database
- Show databases
- Create database
- Delete database
- Create user
- List users
- List databases
- List tables:
show tables - GRANT
See also
GRANT,\ddp,GRANT USAGE,GRANT ALL PRIVILEGES,GRANT SELECT, View GRANTs on Redshift,has_table_privilege,has_schema_privilege,HAS_DATABASE_PRIVILEGE,SCHEMA, Privileges,GRANT EXECUTE
Advertising:
