You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@shiro.apache.org by smm <st...@hcs.us.com> on 2016/07/28 20:08:26 UTC

Re: Problem while authenticating with shiro

What is the problem you're seeing?



--
View this message in context: http://shiro-user.582556.n2.nabble.com/Problem-while-authenticating-with-shiro-tp7581184p7581187.html
Sent from the Shiro User mailing list archive at Nabble.com.

Re: Problem while authenticating with shiro

Posted by smm <st...@hcs.us.com>.

You said:

> jdbcRealm.authenticationQuery = "SELECT password FROM tomcat_users WHERE
> user_name = ?" 
> jdbcRealm.userRolesQuery = SELECT role_name FROM tomcat_roles WHERE
> user_name = ? 
> jdbcRealm.permissionsQuery = SELECT user_name FROM tomcat_users_roles
> WHERE role_name = ? 

The first SQL statement has double quotes around it.  The second and third
don't.  Not sure which is correct.



--
View this message in context: http://shiro-user.582556.n2.nabble.com/Problem-while-authenticating-with-shiro-tp7581184p7581188.html
Sent from the Shiro User mailing list archive at Nabble.com.