[jboss-user] [jBPM] - Re: How to modify jbpm-console to make it retrieve user and role list from database?

[Thomas Setiabudi]

Thomas Setiabudi [https://community.jboss.org/people/thomas.setiabudi] created the discussion

"Re: How to modify jbpm-console to make it retrieve user and role list from database?"

To view the discussion, visit: https://community.jboss.org/message/758517#758517

--------------------------------------------------------------
Just in case someone need to do the same thing, here are some technical detail on how to make jbpm-console get list of user and roles from database. 
My Environment: 
1. JBPM5.3 default installer 
2. Changed the DB to SQL Server  https://community.jboss.org/docs/DOC-19221 https://community.jboss.org/wiki/SetUpJBPM53ToUseMSSQLServer2008 
3. change the security-domain of jbpm-console in JBoss AS 7's standalone.xml     
Reference:  http://docs.jboss.org/jbosssecurity/docs/6.0/security_guide/html/Login_Modules.html#sect-DatabaseServerLoginModule http://docs.jboss.org/jbosssecurity/docs/6.0/security_guide/html/Login_Modules.html#sect-DatabaseServerLoginModule 
if my database tables are: 
dbo.User(UserLogon VARCHAR(64) PRIMARY KEY, Password VARCHAR(64)) 
dbo.UserRole (UserLogon VARCHAR(64), RoleName VARCHAR(32)) 
in standalone.xml look for this section:                   

 <security-domain name="jbpm-console" cache-type="default">
                    <authentication>
                        <login-module code="UsersRoles" flag="required">
                            <module-option name="usersProperties" value="${jboss.server.config.dir}/users.properties"/>
                            <module-option name="rolesProperties" value="${jboss.server.config.dir}/roles.properties"/>
                        </login-module>
                    </authentication>
                </security-domain>



and change it to:
 <security-domain name="jbpm-console" cache-type="default">
                    <authentication>
                        <login-module code="UsersRoles" flag="required">
                            <module-option name="usersProperties" value="${jboss.server.config.dir}/users.properties"/>
                            <module-option name="rolesProperties" value="${jboss.server.config.dir}/roles.properties"/>
                        </login-module>
                    </authentication>
                </security-domain>




Hope it can be useful
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/758517#758517]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20120907/5048efa2/attachment.html