Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Any good examples/references implementing ACLs via SQL?

Tags:

sql

mysql

acl

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 efficiently in SQL.

Thanks!

like image 540
FilmJ Avatar asked May 19 '10 18:05

FilmJ


1 Answers

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

like image 76
JSR Avatar answered Sep 18 '22 13:09

JSR