summaryrefslogtreecommitdiffstats
path: root/sql/pgets-access.sql
diff options
context:
space:
mode:
authorLennart Poettering <lennart@poettering.net>2004-03-07 18:56:13 +0000
committerLennart Poettering <lennart@poettering.net>2004-03-07 18:56:13 +0000
commitec5f0f5729a454e203621bbe66ac86028282b636 (patch)
tree4de87ac9cfbada265daadbf847d0573deffabbc1 /sql/pgets-access.sql
parent285f7ad7d0aed48cd5cb13a2437e80d26fffc254 (diff)
add documentation
assorted other fixes git-svn-id: file:///home/lennart/svn/public/pgets/trunk@4 768266df-afd4-0310-94a7-d396c829e022
Diffstat (limited to 'sql/pgets-access.sql')
-rw-r--r--sql/pgets-access.sql6
1 files changed, 4 insertions, 2 deletions
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;