diff options
Diffstat (limited to 'sql/pgets-access.sql')
-rw-r--r-- | sql/pgets-access.sql | 38 |
1 files changed, 38 insertions, 0 deletions
diff --git a/sql/pgets-access.sql b/sql/pgets-access.sql new file mode 100644 index 0000000..e4507f5 --- /dev/null +++ b/sql/pgets-access.sql @@ -0,0 +1,38 @@ +-- $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. + +-- Create database + +DROP DATABASE pgets; +CREATE DATABASE pgets; + +\c pgets + +-- Create tables + +\i pgets.sql + +-- Manage access rights + +DROP USER pgets_fill; +CREATE USER pgets_fill PASSWORD 'mahatma'; +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; |