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.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  User/Group Security Design

Author  Topic  SKIBUM Starting Member 32 Posts Posted - 2001-10-02 : 20:52:12 All: I'm in the intial phase of designing a new application that is going to need to have group and user-level security rights. These are the assumptions I'm working with. 1) A User can be a member of many Groups. 2) There are 8 different Security Rights 3) Rights can be defined per User. 4) Rights can be defined per Group. 5) Users will inherit the rights of the Group(s) they belong to. I imagine this working very similar to the way NT Permissions work. Has anybody ever encountered this type of situation before? I'm not looking for a solution to this setup, just some ideas as to where to start, maybe a basic table structure. Any help would be appreciated. The app would run on SQL Server 2000. Thanks for any advice in advance.