complex access control system

Posted by Atul Gupta on Programmers See other posts from Programmers or by Atul Gupta
Published on 2012-06-04T06:49:27Z Indexed on 2012/06/04 10:50 UTC
Read the original article Hit count: 312

Filed under:

I want to build a complex access control system just like Facebook.

How should I design my database so that:

  • A user may select which streams to see (via liking a page) and may further select to see all or only important streams.
  • Also he get to see posts of a friend, but if a friend changes visibility he may or may not see it.
  • A user may be an owner or member of a group and accordingly he have access.
    So for a user there is so many access related information and also for each data point.

I use Perl/MySQL/Apache. Any help will be appreciated.

© Programmers or respective owner

Related posts about database-design