View Single Post
  #1 (permalink)  
Old February 27th, 2012, 09:41 PM
vbboyd vbboyd is offline
Friend of Wrox
Points: 1,905, Level: 17
Points: 1,905, Level: 17 Points: 1,905, Level: 17 Points: 1,905, Level: 17
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2011
Posts: 411
Thanks: 13
Thanked 7 Times in 7 Posts
Default Chapter 16 Security Authorization Question

Hypothetical question and practical real world example: Suppose that you have 8 or maybe 9 different user groups that you wanted to display certain database information to on your hypothetical website of say something like "ImarProductions.com"?
The first user group is a group that is just regular subscribers and they only get to see just basic general basic information that is contained in the main database. The second group belongs to users that want to see online CD sells and only that part of the database. The third group wants to see the latest concert information and you only want to supply information to them about the latest concert information and nothing else. The fourth group is only interested at looking at the online reviews of the latest concerts and CD. The fifth group of people are only interested in finding out more information about ticket sales. The sixth group of people is only interested in purchasing CD, Ipads, Iphones and Xbox gaming equipment. The Seventh group of persons logging in to your website is only interested in purchasing Concert Posters, T-shirts and Conert Photos, and the eighth group of people are interested are inverstors in your website and they are only interested in logging in to see user statistics and financial information and other things of that nature. The ninth group of people are subscribers and have paid a subscription fee to see certain inside information and inside scoops from your website on the newest music groups that are the big item performers. How would you create separate user groups that saw different sets of data from the database using different SQL queries that only pertained to them and their specific interests based on their login profiles?
Reply With Quote