CODEWITHSUNDEEP
sqlmysqlacl
FilmJ
FilmJ

Reputation: 2011

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

Thanks!

Upvotes: 9

Views: 4793

Answers (2)

user1796342
user1796342

Reputation:

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

Upvotes: 0

JSR
JSR

Reputation: 6396

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

Upvotes: 5

Related Questions