From ec5f0f5729a454e203621bbe66ac86028282b636 Mon Sep 17 00:00:00 2001 From: Lennart Poettering Date: Sun, 7 Mar 2004 18:56:13 +0000 Subject: add documentation assorted other fixes git-svn-id: file:///home/lennart/svn/public/pgets/trunk@4 768266df-afd4-0310-94a7-d396c829e022 --- sql/pgets-access.sql | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) (limited to 'sql/pgets-access.sql') diff --git a/sql/pgets-access.sql b/sql/pgets-access.sql index e4507f5..3ecfa10 100644 --- a/sql/pgets-access.sql +++ b/sql/pgets-access.sql @@ -29,10 +29,12 @@ CREATE DATABASE pgets; -- Manage access rights +-- A user for the transfer program with write access to the table DROP USER pgets_fill; CREATE USER pgets_fill PASSWORD 'mahatma'; +GRANT INSERT ON pgets_accounting TO pgets_fill; + +-- A user for the web frontend with read access to the table DROP USER pgets_web; CREATE USER pgets_web PASSWORD 'gandhi'; - -GRANT INSERT ON pgets_accounting TO pgets_fill; GRANT SELECT ON pgets_accounting TO pgets_web; -- cgit