Tirsdag 20. juli 2010 09.31.51 skrev alex : > Hi > > In http://wiki.dovecot.org/Variables I found: > %s service imap, pop3, smtp, deliver > and that can be use in userdb and SQL query string. > > How exactly can I use %s in the query string if I want for ex to disable > a service (just one service - ex pop3) for a specific user. > > Alex
While I've not tried it, I guess you could do something like this in the SQL query; ".. AND service=('%s' OR 'all')" You could set the default value of service column to 'all', but set it to 'imap' for users that can only use that service. Arne -- -------------------------------- Arne K. Haaje | www.drlinux.no T: 69 51 15 52 | M: 92 88 44 66 --------------------------------