postgres user rights update

diff --git a/doc/INSTALL.postgresql b/doc/INSTALL.postgresql
index 061d471..7311d29 100755 (executable)
--- a/doc/INSTALL.postgresql
+++ b/doc/INSTALL.postgresql
@@ -84,6 +84,12 @@ change to the start-scripts folder in the contrib-part.
    /usr/local/pgsql/bin/createdb test
    /usr/local/pgsql/bin/psql test
 
+8a. Postgresql user
+
+       See INSTALL.mir for basic dealing with postgresql user.
+       Use 'createdb -U postgres' to create a Database. Create
+       tables with different User inside the Database.
+
 
 Fine! - now you can continue with the postgresql-section in INSTALL.mir
 Good luck.

diff --git a/doc/MAINTENANCE b/doc/MAINTENANCE
index 907411a..1f0c387 100755 (executable)
--- a/doc/MAINTENANCE
+++ b/doc/MAINTENANCE
@@ -15,3 +15,26 @@ be "cleaned". See postgresql docs for commands VACUUM and VACUUM ANALYZE
 
 We also have misc. perl scripts to merge Large Objects from other DB's.
 these can be used as a basis to write your own custom scripts.
+
+
+USER MANAGMENT IN POSTGRESQL
+
+-- set owner of datbase
+select * from pg_database;
+select * from pg_user;
+update pg_database set datdba=ID_FROM_PG_USER where datname=DATABASENAME
+
+-- find all tables to grant privs / select is just building sql
+-- to be exectued
+
+select 'grant all on '||relname||' to "de_indy";'
+from pg_class
+where relname not like 'pg%'
+order by relname;
+
+-- alter table owner / select is just building sql
+-- to be exectued
+select 'alter table '||relname||' owner to "de_indy";'
+from pg_class
+where relname not like 'pg%'
+order by relname;
\ No newline at end of file