File: 01-psql-grants

package info (click to toggle)
phpwiki 1.3.12p3-5etch1
  • links: PTS
  • area: main
  • in suites: etch
  • size: 16,956 kB
  • ctags: 21,608
  • sloc: php: 82,335; xml: 3,840; sh: 1,522; sql: 1,198; perl: 625; makefile: 562; awk: 28
file content (21 lines) | stat: -rw-r--r-- 808 bytes parent folder | download | duplicates (2)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
#! /bin/sh /usr/share/dpatch/dpatch-run
## psql-grant by  <debian@mattb.net.nz>
##
## All lines beginning with `## DP:' are a description of the patch.
## DP: Remove extraneous grant statements that cause confusion 
## DP: from the postgres schema. 
## DP: 
## DP: See #367422

@DPATCH@

--- phpwiki-1.3.12p3.orig/schemas/psql-initialize.sql
+++ phpwiki-1.3.12p3/schemas/psql-initialize.sql
@@ -218,7 +218,6 @@
 GRANT SELECT,INSERT,UPDATE,DELETE ON :session_tbl	TO :httpd_user;
 -- you may want to fine tune this:
 GRANT SELECT,INSERT,UPDATE,DELETE ON :pref_tbl		TO :httpd_user;
--- GRANT SELECT ON :user_tbl	TO :httpd_user;
 -- GRANT SELECT ON :member_tbl	TO :httpd_user;
 GRANT SELECT,INSERT,UPDATE,DELETE ON :rating_tbl	TO :httpd_user;
 GRANT SELECT,INSERT,UPDATE,DELETE ON :accesslog_tbl	TO :httpd_user;