You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@guacamole.apache.org by vn...@apache.org on 2017/06/03 23:56:44 UTC
[4/5] incubator-guacamole-manual git commit: GUACAMOLE-314: Document
that PostgreSQL permissions need to be re-granted after upgrading.
GUACAMOLE-314: Document that PostgreSQL permissions need to be re-granted after upgrading.
Project: http://git-wip-us.apache.org/repos/asf/incubator-guacamole-manual/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-guacamole-manual/commit/277586d1
Tree: http://git-wip-us.apache.org/repos/asf/incubator-guacamole-manual/tree/277586d1
Diff: http://git-wip-us.apache.org/repos/asf/incubator-guacamole-manual/diff/277586d1
Branch: refs/heads/staging/0.9.13-incubating
Commit: 277586d10addadea9fe6034dcbfa986398930b60
Parents: c659c81
Author: Michael Jumper <mj...@apache.org>
Authored: Thu Jun 1 23:57:39 2017 -0700
Committer: Michael Jumper <mj...@apache.org>
Committed: Fri Jun 2 22:56:08 2017 -0700
----------------------------------------------------------------------
src/chapters/jdbc-auth.xml | 16 ++++++++++++++++
1 file changed, 16 insertions(+)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-guacamole-manual/blob/277586d1/src/chapters/jdbc-auth.xml
----------------------------------------------------------------------
diff --git a/src/chapters/jdbc-auth.xml b/src/chapters/jdbc-auth.xml
index 64ac2dc..710a2ff 100644
--- a/src/chapters/jdbc-auth.xml
+++ b/src/chapters/jdbc-auth.xml
@@ -275,6 +275,22 @@ ALTER TABLE
ALTER TABLE</computeroutput>
<prompt>$</prompt></screen>
</informalexample>
+ <para>Because the permissions granted to the Guacamole-specific PostgreSQL user when
+ the database was first created will not automatically be granted for any new
+ tables and sequences, you will also need to re-grant those permissions after
+ applying any upgrade relevant scripts:</para>
+ <informalexample>
+ <screen><prompt>$</prompt> <userinput>psql -d <replaceable>guacamole_db</replaceable></userinput>
+<computeroutput>psql (9.3.6)
+Type "help" for help.
+</computeroutput>
+<prompt>guacamole=# </prompt><userinput>GRANT SELECT,INSERT,UPDATE,DELETE ON ALL TABLES IN SCHEMA public TO <replaceable>guacamole_user</replaceable>;</userinput>
+<computeroutput>GRANT</computeroutput>
+<prompt>guacamole=# </prompt><userinput>GRANT SELECT,USAGE ON ALL SEQUENCES IN SCHEMA public TO <replaceable>guacamole_user</replaceable>;</userinput>
+<computeroutput>GRANT</computeroutput>
+<prompt>guacamole=# </prompt><userinput>\q</userinput>
+<prompt>$</prompt></screen>
+ </informalexample>
<para>If there are no
<filename>upgrade-pre-<replaceable>VERSION</replaceable>.sql</filename>
scripts present in the <filename>schema/upgrade/</filename> directory which