Regarding Row Security, yes you can use it with a web application and still use connection pooling.<p>From web server, connect to db as one user then SET ROLE to the database user. This gives you Column Security and easier auditing as well. See <a href="http:&#x2F;&#x2F;stackoverflow.com&#x2F;questions&#x2F;2998597&#x2F;switch-role-after-connecting-to-database" rel="nofollow">http:&#x2F;&#x2F;stackoverflow.com&#x2F;questions&#x2F;2998597&#x2F;switch-role-after...</a>