Any good examples/references implementing ACLs via SQL?

I currently have a web-application that implements a rudimentary form of ACL using UNIONs in mysql, but it's somewhat limited, and doesn't necessarily scale that well

I'm interested in any alternative ACL algorithms that could be implemented eff开发者_开发问答iciently in SQL.

Thanks!

I've used this document as a model for implementing row level security in a Sql Server based CRM system. In my implementation, rows are made available to a given user based on their Active Directory group memberships.

The performance was surprisingly good when appropriately indexed.

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

Here is a solution for unix like file permissions in sqlite, which I wrote. I do not know however how performant it ist:

https://github.com/orgesleka/unix-acl-sql