title: Spring security with database and multiple roles?
body: <p>I'm trying to make an application using spring 3.0.
  Now I've decided to try my hand at spring-security and hibernate.
  I've already seen that it's possible to back it with a databasem and I've seen a reference to defining your own queries?</p>
  
  <p>Now the problem I have is that the tutorials I've been finding aren't too clear and that they assume that a user can only have one role. I want to give some users multiple roles.</p>
  
  <p>So I was thinking about a database scheme along the lines of:</p>
  
  <p><strong>User:</strong></p>
  
  <ul>
  <li>user_id </li>
  <li>username </li>
  <li>password</li>
  <li>registrationDate</li>
  </ul>
  
  <p><strong>User_Role:</strong></p>
  
  <ul>
  <li>user_id</li>
  <li>role_id</li>
  </ul>
  
  <p><strong>Role:</strong></p>
  
  <ul>
  <li>role_id </li>
  <li>rolename</li>
  </ul>
  
  <p>Now I was wondering if anyone had some pointers to some usefull tutorials/advice/comments.</p>