Individual SQL account per user?
Yes, plenty :) 


You will have to setup encryption from the application server to the database server as the password is passed in clear text. 
All login requests from the internet will result in an expensive authentication request to the database server.
You are not able to use connection pooling which will result in having a single connection for each user accessing the database.