update from MDM

[mir.git] / doc / MAINTENANCE

diff --git a/doc/MAINTENANCE b/doc/MAINTENANCE
index 907411a..df5cae5 100755 (executable)
--- a/doc/MAINTENANCE
+++ b/doc/MAINTENANCE
@@ -15,3 +15,25 @@ 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