Business Connectivity Service with “Item Level” security and PDF forms

To summarize we successfully implemented a row-level security in SQL database and integrated all pieces together. The point is that while SharePoint 2010 Business Connectivity Service has limitations, it does not mean your implementation should be limited. By understanding surrounding technologies like SQL Server, PDF SharePoint you can achieve item level security and display external data in the PDF document.