Difference between revisions of "GRANT SELECT ON mytable TO xxx"
Jump to navigation
Jump to search
| (One intermediate revision by the same user not shown) | |||
| Line 2: | Line 2: | ||
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; | ||
| Line 7: | Line 10: | ||
== 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:
