<subsystem xmlns="urn:jboss:domain:security:1.2">
            <security-domains>
                <security-domain name="NewsSD">
                    <authentication>
                        <login-module code="Database" flag="required">
                            <module-option name="dsJndiName" value="java:jboss/datasources/NewsDS"/>
                            <module-option name="principalsQuery" value="SELECT password AS 'Password' FROM t_user WHERE username = ?"/>
                            <module-option name="rolesQuery" value="SELECT r.rolename, 'Roles' FROM t_user u INNER JOIN t_user_role ur ON u.userid = ur.userid INNER JOIN t_role r ON ur.roleid = r.roleid WHERE u.username = ?"/>
                            <module-option name="hashAlgorithm" value="SHA-512"/>
                            <module-option name="hashEncoding" value="hex"/>
                        </login-module>
                    </authentication>
                </security-domain>
                <security-domain name="other" cache-type="default">