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



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!