Difference between revisions of "GRANT SELECT ON DATABASE"
Jump to navigation
Jump to search
| (5 intermediate revisions by 2 users not shown) | |||
| Line 2: | Line 2: | ||
| − | [[GRANT SELECT ON DATABASE | + | [[GRANT SELECT]] ON DATABASE "yourdbname" to yourusername; |
[[Invalid privilege type]] | [[Invalid privilege type]] | ||
| − | + | == Related == | |
| − | GRANT SELECT ON ALL TABLES IN SCHEMA public TO user1; | + | * <code>[[GRANT SELECT ON ALL TABLES]] IN SCHEMA public TO user1;</code> |
| − | ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO user; | + | * <code>ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO user;</code> |
== See also == | == See also == | ||
Latest revision as of 10:34, 16 December 2022
GRANT SELECT ON DATABASE "yourdbname" to yourusername; Invalid privilege type
Related[edit]
GRANT SELECT ON ALL TABLES IN SCHEMA public TO user1;ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO user;
See also[edit]
Advertising:
