SQL Recipes
A FREE cookbook for SQL queries and examples
Register FAQ Search Today's Posts Mark Forums Read

Database Design Find articles on variouse database design topics

Go Back   SQL Recipes a FREE cookbook of SQL queries and examples > Articles > Database Design

Reply
 
LinkBack (50) Thread Tools Search this Thread Rating: Thread Rating: 2 votes, 5.00 average.
  #61 (permalink)  
Old 10-08-2008, 01:44 AM
FarshadV FarshadV is offline
Junior Member
 
Join Date: Apr 2008
Posts: 4
FarshadV is on a distinguished road
Default Re: Fine Grained Role Based Access Control (RBAC) system

Quote:
Originally Posted by Dimitar View Post
Hello,

I am curious, how are you going to enter 5000 items in the RBAC tables?

Best Regards,

Dimitar
If I am understanding this system correctly, each entry is a file within my intended system. The initial loading of all files on to the server and the creation of associated db records will be programmatic.

Farshad
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #62 (permalink)  
Old 10-08-2008, 06:43 PM
Dimitar
 
Posts: n/a
Default Re: Fine Grained Role Based Access Control (RBAC) system

Quote:
Originally Posted by FarshadV View Post
If I am understanding this system correctly, each entry is a file within my intended system. The initial loading of all files on to the server and the creation of associated db records will be programmatic.

Farshad
Thank you!

Dimitar
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Edit/Delete Message Reply With Quote
  #63 (permalink)  
Old 10-10-2008, 01:17 AM
swamp swamp is offline
Junior Member
 
Join Date: Sep 2008
Posts: 2
swamp is on a distinguished road
Default Re: Fine Grained Role Based Access Control (RBAC) system

Hi Ben,

Here goes the patch as I promised in last post.
rbac_patches.zip

Note:
1. patch also incorporates two fixes from this forum and class.rbacAdmin_bv.php and class.rbac_bv.php from your RBAC.zip
2. patch is against vanilla rbac_admin
3. there are two versions of patch, one for unix and other for windows environment (difference in cr/nl or nl)

How to apply patch?
uncompress patch archive
choose the patch based on your environment
copy patch to path_to_vanilla_rbac_admin
cd path_to_vanilla_rbac_admin
patch -p1 patch

Examples of use are in function PrintPage of class.page_bv.php
Be warned that I didn't make test on windows at all.

Cheers,
Sinisa
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #64 (permalink)  
Old 10-10-2008, 07:18 AM
ben ben is offline
Administrator
 
Join Date: Mar 2007
Posts: 93
ben has disabled reputation
Default Re: Fine Grained Role Based Access Control (RBAC) system

Quote:
Originally Posted by swamp View Post
Hi Ben,

Here goes the patch as I promised in last post.
Attachment 11

Note:
1. patch also incorporates two fixes from this forum and class.rbacAdmin_bv.php and class.rbac_bv.php from your RBAC.zip
2. patch is against vanilla rbac_admin
3. there are two versions of patch, one for unix and other for windows environment (difference in cr/nl or nl)

How to apply patch?
uncompress patch archive
choose the patch based on your environment
copy patch to path_to_vanilla_rbac_admin
cd path_to_vanilla_rbac_admin
patch -p1 patch

Examples of use are in function PrintPage of class.page_bv.php
Be warned that I didn't make test on windows at all.

Cheers,
Sinisa
Thanks a lot Sinisa. That is great.
Cheers,

Ben
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #65 (permalink)  
Old 11-15-2008, 04:37 PM
koen koen is offline
Junior Member
 
Join Date: Nov 2008
Posts: 2
koen is on a distinguished road
Default Re: Fine Grained Role Based Access Control (RBAC) system

Hi,

I'm not sure whether your RBAC system can solve the following problem. So I hope you could give me some help.

Some blogposts exist. Permissions apply based on a variety of conditions. Eg an admin may view all posts, a regular user can only view posts that don't have the 'draft' status.

This could probably be solved easily by creating 2 domains: posts and drafts (or something alike). But suppost additional rules exist. The regular users also cannot view posts that are in category 'premium', or tagged with 'pending review'. This would mean an explosion of domains (all the combinations).

How would your system solve this?

Thanks
Koen
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #66 (permalink)  
Old 11-17-2008, 12:33 PM
ben ben is offline
Administrator
 
Join Date: Mar 2007
Posts: 93
ben has disabled reputation
Default Re: Fine Grained Role Based Access Control (RBAC) system

Quote:
Originally Posted by koen View Post
Hi,

I'm not sure whether your RBAC system can solve the following problem. So I hope you could give me some help.

Some blogposts exist. Permissions apply based on a variety of conditions. Eg an admin may view all posts, a regular user can only view posts that don't have the 'draft' status.

This could probably be solved easily by creating 2 domains: posts and drafts (or something alike). But suppost additional rules exist. The regular users also cannot view posts that are in category 'premium', or tagged with 'pending review'. This would mean an explosion of domains (all the combinations).

How would your system solve this?

Thanks
Koen
Domains are collections of objects. In your case you will have the following objects:
- post
- draft
- premium
- pending

Based on these objects you can create domains. And it is not as complex or large as it seems. (The system is meant to efficiently deal with thousands of objects and actions).

In your case it would probably be easier to define what a regular user CAN do since by default the system will NOT allow a user to perform an action if it is not defined.

So if you define a rule that allows a regular user to view a standard post, by definition that same user will NOT be able to view anything else. So that rule would be really simple.

However to get to what you were asking you could create a domain called 'regular_user_not_viewable_objects' and add the corresponding objects to that domain, But it would really not be the best approach.

As a rule of thumb you always want to focus (or define) what a user CAN do. It is only when an object in a larger domain (or an action in a larger privilege) conflicts with the rule that you generally specifically exclude it. That is really the only time you would want to define negative rules. (Look at the first post and see how I define the rules for 'moderators'.)

Hope this helps.

Ben
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #67 (permalink)  
Old 11-18-2008, 05:36 PM
koen koen is offline
Junior Member
 
Join Date: Nov 2008
Posts: 2
koen is on a distinguished road
Default Re: Fine Grained Role Based Access Control (RBAC) system

Quote:
Originally Posted by ben View Post
Domains are collections of objects. In your case you will have the following objects:
- post
- draft
- premium
- pending

Based on these objects you can create domains. And it is not as complex or large as it seems. (The system is meant to efficiently deal with thousands of objects and actions).
From the examples in the first post I understand that domains and objects do not refer to domain models and business objects (as in the model layer of a MVC approach). So in order to determine whether a user can view a post I would create a postModel and translate its properties (such as being a draft, pending etc) to the objects defined in the RBAC system.

Am I right so far?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Rate This Thread
Rate This Thread:

Posting Rules
You may post new threads
You may post replies
You may not post attachments
You may edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

LinkBacks (?)
LinkBack to this Thread: http://www.sqlrecipes.com/database_design/fine_grained_role_based_access_control_rbac_system-3/
Posted By For Type Date
RBAC - Forum PHP.pl This thread Refback 06-04-2008 03:11 PM
RBAC - Forum PHP.pl This thread Refback 05-23-2008 02:22 PM
Joomla! Community Forum • View topic - [15]Access Management in Joomla! 1.6 This thread Refback 05-05-2008 07:07 AM
Joomla! Community Forum • View topic - [15]Access Management in Joomla! 1.6 This thread Refback 05-03-2008 03:57 PM
RBAC - Forum PHP.pl This thread Refback 05-02-2008 03:46 PM
Discover From Your Favorite Topic or Web Page: rbac This thread Refback 04-18-2008 03:58 AM
[PHP/SQL] Ideale rechtensysteem - Programming - GoT This thread Refback 04-17-2008 11:12 PM
Joomla! Community Forum • View topic - [15]Access Management in Joomla! 1.6 This thread Refback 04-10-2008 08:51 PM
[PHP/SQL] Ideale rechtensysteem - Programming - GoT This thread Refback 04-07-2008 01:26 PM
[PHP/SQL] Ideale rechtensysteem - Programming - GoT This thread Refback 04-07-2008 12:34 PM
[PHP/SQL] Ideale rechtensysteem - Programming - GoT This thread Refback 04-07-2008 12:32 PM
[PHP/SQL] Ideale rechtensysteem - Programming - GoT This thread Refback 04-07-2008 12:31 PM
Joomla! Community Forum • View topic - I want better ACL This thread Refback 03-21-2008 12:00 PM
Qwait's favorite web pages, page 6 - StumbleUpon This thread Refback 03-20-2008 02:35 AM
Rechtensysteem voor website - Software Engineering & Architecture - GoT This thread Refback 03-06-2008 05:17 PM
Joomla! Community Forum • View topic - I want better ACL This thread Refback 03-01-2008 02:30 AM
Joomla! Community Forum • View topic - I want better ACL This thread Refback 02-29-2008 12:59 PM
Joomla! Community Forum • View topic - I want better ACL This thread Refback 02-29-2008 10:44 AM
Joomla! Community Forum • View topic - I want better ACL This thread Refback 02-25-2008 12:48 PM
Rechtensysteem voor website - Software Engineering & Architecture - GoT This thread Refback 02-22-2008 09:46 PM
RBAC - Forum PHP.pl This thread Refback 02-20-2008 04:37 PM
RBAC - Forum PHP.pl This thread Refback 02-20-2008 02:29 PM
RBAC - Forum PHP.pl This thread Refback 02-20-2008 02:17 PM
Rechtensysteem voor website - Software Engineering & Architecture - GoT This thread Refback 02-08-2008 04:12 PM
Rechtensysteem voor website - Software Engineering & Architecture - GoT This thread Refback 02-05-2008 09:17 AM
atakan.dogan's bookmarks tagged with This thread Refback 01-10-2008 07:16 AM
Pages tagged with This thread Refback 01-08-2008 01:01 PM
atakan.dogan's bookmarks on del.icio.us This thread Refback 01-07-2008 09:26 AM
heberm's bookmarks tagged with This thread Refback 01-06-2008 10:12 PM
Rechtensysteem voor website - Software Engineering & Architecture - GoT - Powered by React This thread Refback 01-06-2008 07:05 PM
qWikiOffice Blog » Blog Archive » Database Design This thread Refback 01-05-2008 07:03 PM
Rechtensysteem voor website - Software Engineering & Architecture - GoT - Powered by React This thread Refback 12-25-2007 10:00 AM
Rechtensysteem voor website - Software Engineering & Architecture - GoT - Powered by React This thread Refback 12-22-2007 02:39 PM
amii's bookmarks on del.icio.us This thread Refback 12-21-2007 02:02 PM
ECRM:AccessControl - FaithHighway Wiki This thread Refback 12-19-2007 10:34 PM
Which is best for ACL? | CodeIgniter Forums This thread Refback 12-02-2007 03:45 AM
Rechtensysteem voor website - Software Engineering & Architecture - GoT - Powered by React This thread Refback 11-10-2007 03:26 PM
StumbleUpon » deepakpradhan's web site reviews and blog This thread Refback 11-04-2007 12:18 AM
scorpiol's bookmarks on del.icio.us This thread Refback 10-21-2007 10:23 AM
Rechtensysteem voor website - Software Engineering & Architecture - GoT - Powered by React This thread Refback 10-19-2007 02:26 PM
Rechtensysteem voor website - Software Engineering & Architecture - GoT - Powered by React This thread Refback 10-18-2007 09:38 PM
Rechtensysteem voor website - Software Engineering & Architecture - GoT - Powered by React This thread Refback 10-18-2007 09:36 PM
mithras86's bookmarks tagged with This thread Refback 09-28-2007 10:06 PM
mithras86's bookmarks on del.icio.us This thread Refback 09-24-2007 02:22 PM
heberm's bookmarks on del.icio.us This thread Refback 08-30-2007 01:46 PM
onisemus' bookmarks tagged with This thread Refback 08-14-2007 10:15 PM
onisemus' bookmarks on del.icio.us This thread Refback 08-02-2007 03:40 PM
Scaffolding | CodeIgniter Forums This thread Refback 07-06-2007 10:41 AM
konvergal's bookmarks on del.icio.us This thread Refback 06-29-2007 11:06 PM
dynasync's bookmarks tagged with This thread Refback 06-26-2007 02:39 AM


All times are GMT. The time now is 10:24 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.0.0
Copyright (c) 2006-2008 SQL Recipes

1 2 3 4 5 6 7 8