Using ProFTPD and its SQL module for MySQL, it is possible to give FTP access to non system users. By doing so, one can give access to a Virtual User which is only allowed to use the FTP service.
This Tutorial will show how to create and populate the user and group tables as well as configure proftpd in order to use the MySQL backend.
