diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2004-01-14 03:46:28 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2004-01-14 03:46:28 +0000 |
| commit | d505f30281ecf29fd6d39127621cbe783bc9b0eb (patch) | |
| tree | 1bb96ef2f1e5e8977d18cebadd50cdf5d04f9aaa | |
| parent | 7562103f6e77fe3b4fad6a7eba8c59f51627b30c (diff) | |
| download | postgresql-d505f30281ecf29fd6d39127621cbe783bc9b0eb.tar.gz postgresql-d505f30281ecf29fd6d39127621cbe783bc9b0eb.zip | |
pg_settings should have UPDATE privilege allowed to public.
| -rw-r--r-- | src/backend/catalog/system_views.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/src/backend/catalog/system_views.sql b/src/backend/catalog/system_views.sql index 21f986ebfaa..54256186fd3 100644 --- a/src/backend/catalog/system_views.sql +++ b/src/backend/catalog/system_views.sql @@ -3,7 +3,7 @@ * * Copyright 1996-2003, PostgreSQL Global Development Group * - * $PostgreSQL: pgsql/src/backend/catalog/system_views.sql,v 1.4 2003/12/03 18:52:00 joe Exp $ + * $PostgreSQL: pgsql/src/backend/catalog/system_views.sql,v 1.5 2004/01/14 03:46:28 tgl Exp $ */ CREATE VIEW pg_user AS @@ -271,3 +271,5 @@ CREATE RULE pg_settings_u AS CREATE RULE pg_settings_n AS ON UPDATE TO pg_settings DO INSTEAD NOTHING; + +GRANT SELECT, UPDATE ON pg_settings TO PUBLIC; |