tabela - Usuario----- id_usuario,usuario,senha, id_area;
tabela - Permissoes --------id_area, tipo_permissao ;
<http access-denied-page="/loginError.xhtml">
<intercept-url pattern="/Juridico/**" access="ROLE_ADMIN"/>
<form-login login-page="/login.xhtml" always-use-default-target="true"
default-target-url="/Financeiro/public.xhtml"
authentication-failure-url="/login.xhtml?login_error=1"/>
<logout/>
<remember-me/>
</http>
<authentication-manager>
<authentication-provider>
<jdbc-user-service data-source-ref="dataSource"
users-by-username-query="SELECT usuario,senha FROM usuario WHERE usuario=?"
authorities-by-username-query="select u.usuario,P.tipo_permissao from Usuario u inner join Permissoes P on P.id_area = u.id_area
where u.usuario = ?;"/>
</authentication-provider>
</authentication-manager>
ao tentar login com o Usuario ‘X’ senha x
fazendo o select de authorities retorna isso -------- “X”;“Financeiro”
alguem pode me ajudar nisso???