Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
RoLYroLLs
Constraint Violating Yak Guru
255 Posts |
 Posted - 2005-05-23 : 11:58:05
|
| Hi gals and guys,I'm inquiring about a fairly simple design for user and group permissions.WHAT I HAVE:This is a purely web-based program. I have a table with a list of users. I also have table defining all my groups. I then have another table that lists what users are in what groups. I also have a table with a list of all the pages on the site and another page that links either a user or a group to that page. This forum has the current structure I have [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49985[/url]. I also am trying to build a dynamic menu for each user as well based on their user and usergroup permissions. The structure in he forum above is only the menu, but I was working on one part at a time.WHAT I WANT:I'm willing to drop the design I have for a better one which is why I'm here. My goal is for an administrator to change page permissions per user and/or usergroup programmatically. What does this mean: say I have user1 and he is in group1, if I define group1 to view the users page and user1 to view the statememnts page, then user1 will be able to access both pages while he is logged on, while any other user in group1 will be able to view the users, but not view the statements page (unless defined for him in another group or for his userid.) Any of that make sense? My current design only implements ALLOW, but if I can easy find and implement a good method for deny or allow, that would be great.- RoLY roLLs |
|
|
|
|
|
User/UserGroup Permissions Design