GUACAMOLE-363: Limit scope of role for guacamole database user.
Project: http://git-wip-us.apache.org/repos/asf/guacamole-manual/repo Commit: http://git-wip-us.apache.org/repos/asf/guacamole-manual/commit/b9791ebd Tree: http://git-wip-us.apache.org/repos/asf/guacamole-manual/tree/b9791ebd Diff: http://git-wip-us.apache.org/repos/asf/guacamole-manual/diff/b9791ebd Branch: refs/heads/master Commit: b9791ebd803a5e9b4076a3510166eab404d7bc25 Parents: de0311d Author: Nick Couchman <[email protected]> Authored: Thu Nov 30 08:38:44 2017 -0500 Committer: Nick Couchman <[email protected]> Committed: Thu Nov 30 08:38:44 2017 -0500 ---------------------------------------------------------------------- src/chapters/jdbc-auth.xml | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/guacamole-manual/blob/b9791ebd/src/chapters/jdbc-auth.xml ---------------------------------------------------------------------- diff --git a/src/chapters/jdbc-auth.xml b/src/chapters/jdbc-auth.xml index 70d237e..84f9359 100644 --- a/src/chapters/jdbc-auth.xml +++ b/src/chapters/jdbc-auth.xml @@ -336,7 +336,8 @@ Type "help" for help. <prompt>2></prompt> <userinput>GO</userinput> <prompt>1></prompt> <userinput>CREATE USER <replaceable>guacamole_user</replaceable>;</userinput> <prompt>2></prompt> <userinput>GO</userinput> -<prompt>1></prompt> <userinput>ALTER ROLE db_owner ADD MEMBER <replaceable>guacamole_user</replaceable>;</userinput> +<prompt>1></prompt> <userinput>ALTER ROLE db_datawriter ADD MEMBER <replaceable>guacamole_user</replaceable>;</userinput> +<prompt>1></prompt> <userinput>ALTER ROLE db_datareader ADD MEMBER <replaceable>guacamole_user</replaceable>;</userinput> <prompt>2></prompt> <userinput>GO</userinput></screen> </informalexample> <para>Once the database and user account is created, and the user associated with the database, you can use
