Difference between revisions of "GRANT"
Jump to navigation
Jump to search
↑ https://stackoverflow.com/a/10353730
↑ https://dba.stackexchange.com/a/184339
| Line 10: | Line 10: | ||
[[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> | ||
| − | :Command: | + | :Command: <code> GRANT [[your_defined_role]] TO your_username;</code> |
| − | :Output: [[GRANT ROLE]] | + | :Output: <code>[[GRANT ROLE]]</code> |
SELECT * FROM your_table_name; | SELECT * FROM your_table_name; | ||
Revision as of 13:36, 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 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
GRANT SELECT ON mytable TO xxx
- 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:
