Any good examples / links that implement ACLs through SQL?

Question

I currently have a web application that implements a rudimentary form of ACL using UNION in mysql, but it is somewhat limited and does not necessarily scale it well

I am interested in any alternative ACL algorithms that can be effectively implemented in SQL.

Thanks!

Answer 1

I used this document as a model for row-level security in a CRM system based on an Sql server. In my implementation, strings are made available to this user based on their membership in the Active Directory group.

Performance was surprisingly good with proper indexing.

http://msdn.microsoft.com/en-us/library/cc966395.aspx