AuthFilters.groovy

import org.springframework.security.core.Authentication
import org.springframework.security.core.context.SecurityContextHolder


class AuthFilters {

  def springSecurityService
	
	def dataSource
	
	def filters = {
		
		databaseConn(controller: '*', action: '*') {
			before = {
				if(!(controllerName in ['login','logout','password']) && springSecurityService.isLoggedIn()) {
					Authentication auth = SecurityContextHolder.getContext().getAuthentication();
					String username = auth.getName(); //get logged in username
					String password = (String)auth.getCredentials();
					dataSource.setCredentialsForCurrentThread(username, password)
				}	
			}
		}
		
	}
	
}