Difference between revisions of "GRANT"
Jump to navigation
Jump to search
↑ https://stackoverflow.com/a/10353730
↑ https://dba.stackexchange.com/a/184339
| Line 5: | Line 5: | ||
[[SELECT]], INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER, CREATE, CONNECT, TEMPORARY, EXECUTE, [[USAGE]] | [[SELECT]], INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER, CREATE, CONNECT, TEMPORARY, EXECUTE, [[USAGE]] | ||
| + | |||
| + | [[GRANT SELECT ON mytable TO xxx]] | ||
[[GRANT USAGE]] | [[GRANT USAGE]] | ||
| − | |||
[[GRANT USAGE ON]] [[ALL SEQUENCES IN SCHEMA]] your_schema TO mygrp; </code><ref>https://stackoverflow.com/a/10353730</ref> | [[GRANT USAGE ON]] [[ALL SEQUENCES IN SCHEMA]] your_schema TO mygrp; </code><ref>https://stackoverflow.com/a/10353730</ref> | ||
| Line 15: | Line 16: | ||
SELECT * FROM your_table_name; | SELECT * FROM your_table_name; | ||
[[ERROR: permission denied for table]] your_table_name | [[ERROR: permission denied for table]] your_table_name | ||
| − | |||
| − | |||
* List roles: <code>[[\du]]</code> or <code>[[SELECT * FROM pg_roles;]]</code> | * List roles: <code>[[\du]]</code> or <code>[[SELECT * FROM pg_roles;]]</code> | ||
Revision as of 13:37, 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)
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:
