Github user mike-jumper commented on a diff in the pull request:
https://github.com/apache/guacamole-manual/pull/66#discussion_r159111846
--- Diff: src/chapters/jdbc-auth.xml ---
@@ -299,6 +321,60 @@ Type "help" for help.
to run any database upgrade scripts.</para>
</important>
</section>
+ <section xml:id="jdbc-auth-sqlserver">
+ <title>SQL Server</title>
+ <para>If using SQL Server, the database and schema must be
created first. The example below assumes
+ that you are running SQL Server on Linux, using the
command-line tools to manage it.</para>
+ <informalexample>
+ <screen><prompt>$</prompt>
<userinput>/opt/mssql-tools/bin/sqlcmd -S localhost -U SA</userinput>
+<prompt>Password:</prompt>
<userinput><replaceable>password</replaceable></userinput>
+<prompt>1></prompt> <userinput>CREATE DATABASE
<replaceable>guacamole_db</replaceable>;</userinput>
+<prompt>2></prompt> <userinput>GO</userinput>
+<prompt>1></prompt> <userinput>CREATE LOGIN
<replaceable>guacamole_user</replaceable> WITH PASSWORD =
'<replaceable>S0me_Password</replaceable>';</userinput>
+<prompt>2></prompt> <userinput>GO</userinput>
+<prompt>1></prompt> <userinput>USE
<replaceable>guacamole_db</replaceable>;</userinput>
+<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_datawriter ADD MEMBER
<replaceable>guacamole_user</replaceable>;</userinput>
--- End diff --
Reading further to double-check that the permissions granted for
`db_datawriter` and `db_datareader` are not beyond what is required, I found [a
table listing the specific permission granted for
each](https://technet.microsoft.com/en-us/library/ms189612(v=sql.90).aspx):
You're correct - these are entirely equivalent.
---
