From efd4d8bd530d1938f3e72638a5cb972982c30de7 Mon Sep 17 00:00:00 2001 From: Domas Mituzas Date: Fri, 10 Sep 2004 10:58:37 +0000 Subject: [PATCH] virgin pg grants --- maintenance/postgresql/pg_users.sql | 15 +++++++++++++++ 1 file changed, 15 insertions(+) create mode 100644 maintenance/postgresql/pg_users.sql diff --git a/maintenance/postgresql/pg_users.sql b/maintenance/postgresql/pg_users.sql new file mode 100644 index 0000000000..35f117e549 --- /dev/null +++ b/maintenance/postgresql/pg_users.sql @@ -0,0 +1,15 @@ +-- $Id$ +-- access rights for wiki database users +CREATE USER {$wgDBuser} + PASSWORD '{$wgDBpassword}'; + +GRANT SELECT,INSERT,UPDATE,DELETE ON + archive,brokenlinks,categorylinks,cur, + cur_cur_id_seq,hitcounter,image,imagelinks, + interwiki,ipblocks,ipblocks_ipb_id_seq,links, + linkscc,math,objectcache,"old",old_old_id_seq, + oldimage,profiling,querycache,recentchanges, + recentchanges_rc_id_seq,searchindex,site_stats, + site_stats_ss_row_id_seq,"user",user_newtalk, + user_rights,user_user_id_seq,validate,watchlist +TO {$wgDBuser}; -- 2.20.1