Difference between revisions of "GRANT SELECT ON mytable TO xxx"
Jump to navigation
Jump to search
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | GRANT SELECT ON mytable TO xxx | + | GRANT SELECT ON [[mytable]] TO xxx |
[[ERROR: permission denied for relation]] xxxx | [[ERROR: permission denied for relation]] xxxx | ||
| + | |||
| + | GRANT SELECT ON ALL TABLES IN SCHEMA public TO yourdbname; | ||
| + | |||
| + | |||
| + | [[ERROR: permission denied for schema]] your_schema | ||
== See also == | == See also == | ||
| + | * {{SELECT}} | ||
* {{GRANT}} | * {{GRANT}} | ||
[[Category:PostgreSQL]] | [[Category:PostgreSQL]] | ||
Latest revision as of 15:33, 15 December 2022
GRANT SELECT ON mytable TO xxx ERROR: permission denied for relation xxxx
GRANT SELECT ON ALL TABLES IN SCHEMA public TO yourdbname;
ERROR: permission denied for schema your_schema
See also[edit]
Advertising:
