diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/Makefile.am | 19 | ||||
| -rw-r--r-- | sql/pgets-access.sql | 6 |
2 files changed, 23 insertions, 2 deletions
diff --git a/sql/Makefile.am b/sql/Makefile.am new file mode 100644 index 0000000..acb7ee6 --- /dev/null +++ b/sql/Makefile.am @@ -0,0 +1,19 @@ +# $Id$ + +# This file is part of pgets. +# +# pgets is free software; you can redistribute it and/or modify it +# under the terms of the GNU General Public License as published by +# the Free Software Foundation; either version 2 of the License, or +# (at your option) any later version. +# +# pgets is distributed in the hope that it will be useful, but +# WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU +# General Public License for more details. +# +# You should have received a copy of the GNU General Public License +# along with pgets; if not, write to the Free Software Foundation, +# Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA. + +EXTRA_DIST = pgets-access.sql pgets.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; |