3 # bash script to change the owner of a database
8 echo "usage: $0 dbname newowner"
16 SCRIPT_FILE="/tmp/createmir.$$.sql"
18 echo "UPDATE pg_database SET datdba=(select usesysid from pg_user where usename='$2') where datname='$1';" > ${SCRIPT_FILE}
20 echo "\connect $1" >> ${SCRIPT_FILE}
23 echo "grant all on media_type to $2;" >> ${SCRIPT_FILE}
24 echo "grant all on img_format to $2;" >> ${SCRIPT_FILE}
25 echo "grant all on img_layout to $2;" >> ${SCRIPT_FILE}
26 echo "grant all on img_type to $2;" >> ${SCRIPT_FILE}
27 echo "grant all on img_color to $2;" >> ${SCRIPT_FILE}
28 echo "grant all on language to $2;" >> ${SCRIPT_FILE}
29 echo "grant all on rights to $2;" >> ${SCRIPT_FILE}
30 echo "grant all on feature to $2;" >> ${SCRIPT_FILE}
31 echo "grant all on article_type to $2;" >> ${SCRIPT_FILE}
32 echo "grant all on breaking to $2;" >> ${SCRIPT_FILE}
33 echo "grant all on messages to $2;" >> ${SCRIPT_FILE}
34 echo "grant all on comment_status to $2;" >> ${SCRIPT_FILE}
35 echo "grant all on links_imcs to $2;" >> ${SCRIPT_FILE}
36 echo "grant all on other_media to $2;" >> ${SCRIPT_FILE}
37 echo "grant all on webdb_users to $2;" >> ${SCRIPT_FILE}
38 echo "grant all on content_x_topic to $2;" >> ${SCRIPT_FILE}
39 echo "grant all on topic to $2;" >> ${SCRIPT_FILE}
40 echo "grant all on uploaded_media to $2;" >> ${SCRIPT_FILE}
41 echo "grant all on images to $2;" >> ${SCRIPT_FILE}
42 echo "grant all on content_x_media to $2;" >> ${SCRIPT_FILE}
43 echo "grant all on comment_x_media to $2;" >> ${SCRIPT_FILE}
44 echo "grant all on audio to $2;" >> ${SCRIPT_FILE}
45 echo "grant all on video to $2;" >> ${SCRIPT_FILE}
46 echo "grant all on content to $2;" >> ${SCRIPT_FILE}
47 echo "grant all on comment to $2;" >> ${SCRIPT_FILE}
48 echo "grant all on media_folder to $2;" >> ${SCRIPT_FILE}
51 echo "grant all on media_id_seq to $2;" >> ${SCRIPT_FILE}
52 echo "grant all on media_folder_id_seq to $2;" >> ${SCRIPT_FILE}
53 echo "grant all on feature_id_seq to $2;" >> ${SCRIPT_FILE}
54 echo "grant all on topic_id_seq to $2;" >> ${SCRIPT_FILE}
55 echo "grant all on webdb_users_id_seq to $2;" >> ${SCRIPT_FILE}
56 echo "grant all on comment_id_seq to $2;" >> ${SCRIPT_FILE}
57 echo "grant all on breaking_id_seq to $2;" >> ${SCRIPT_FILE}
58 echo "grant all on messages_id_seq to $2;" >> ${SCRIPT_FILE}
59 echo "grant all on media_type_id_seq to $2;" >> ${SCRIPT_FILE}
60 echo "grant all on links_imcs_id_seq to $2;" >> ${SCRIPT_FILE}
61 echo "grant all on comment_status_id_seq to $2;" >> ${SCRIPT_FILE}
62 echo "grant all on article_type_id_seq to $2;" >> ${SCRIPT_FILE}
63 echo "grant all on language_id_seq to $2;" >> ${SCRIPT_FILE}
67 psql -f ${SCRIPT_FILE} -d template1 |uniq -c