Re: Shiro and JSF problems

[kait]

Hi. 

I have now tested it using iniRealm, and the everything works just fine...
So I guess I have muddled the creation of the database. 

CREATE TABLE users (
    id SERIAL PRIMARY KEY,
    username varchar(32) NOT NULL UNIQUE,
    password varchar(32) NOT NULL
);

CREATE TABLE user_roles (
   id SERIAL PRIMARY KEY,
   role_name varchar(32) NOT NULL,
   username varchar(32)   
);

CREATE TABLE roles_permission(
   id SERIAL PRIMARY KEY,
   permission varchar(64) NOT NULL,
   role_name varchar(64)  
);

Can anyone spot a mistake that would lead to none of my users having any
permissions?
-- 
View this message in context: 
http://shiro-user.582556.n2.nabble.com/Shiro-and-JSF-problems-tp5700715p5720903.html
Sent from the Shiro User mailing list archive at Nabble.com.