Thread: Permission - Role Based data model
View Single Post
  #13 (permalink)  
Old 07-01-09, 10:18
pootle flump pootle flump is offline
King of Understatement
  
Join Date: Feb 2004
Location: One Flump in One Place
Posts: 14,905
Quote:
Originally Posted by sqlguru
I don't think that will work.
...because?

Quote:
Originally Posted by sqlguru
How about this model:
Fine Grained Role Based Access Control (RBAC) system - SQL Recipes a FREE cookbook of SQL queries and examples

I haven't built an RBAC system before (usually use simpler ACL system) but does the above model have any performance implications?
Not used. More importantly, does this meet requirements your current model does not? Because this is driven by a business need, not a technical one. It is your model just extended with more granular controls AFAICT.
__________________
Testimonial:
Quote:
pootle flump
ur codings are working excelent.
Reply With Quote