[Dovecot] about variables

[alex]

On 07/20/2010 11:31 AM, Arne K. Haje wrote:
>   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

How about
"...AND %s in (services)"
and the services column will be something like 'imap,pop3,smtp,deliver'
=> "...AND %s in (imap,pop3,smtp,deliver)"
For the user that do not have , let say imap, the services will be 
(pop3,smtp,deliver)

Further more : the postfix server use the dovecot auth. It is possible 
for an account to disable the smtp auth (the user won't be able to send 
any emails but will be able to receive an read )?

Alex