advice on data model

S

Stacey Howard

Can some please review my small security data model and advise according
please. I have users which can be assigned to groups, and those groups can
have several rights associated it with them. Is my data model correct? In
the rights table is where I define my rights, these rights are actually
codes I use on forms in my application, just wanted to note that. Basically
I want to be able to create a user, assign that user to a group and be able
to assign that group certain rights. So when the user logs in, the rights
associated with his group with be used. Thanks. Stacey

Here are the tables with a few fields:
1. tblUser
-pkSecurityUser
-Name
-PWD

2. tblUersGroups
-pkUserGrpID
-fkSecurityUserID
-fkGroupID

3. tblGrpRights
-pkGrpRightsID
-fkGroupID
-fkRightsID
-permission (RO,RW)

4. tblGroups
-pkUserGrpID
-fkSecurityUserID
-fkGroupID

5. tblRights
-pkRightsID
-RightsDescription

Relationships:

tblUser 1-N tblUersGroups
tblUersGroups N-1 tblGroups
tblGroups 1-N tblGrpRights
tblGrpRights N-1 tblRights
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Please advise on data model 3
Modeling Question: Country | Region | Sub-Region 3
Problem creating database 3
Any way to use "RunPermissions=OWNER" with multi-MDW security model? 0
Filter View based on field in a reoccurring group 0
Technique used to rotate text labels when creating a PDF file fromAccess 1
Cyclic Data Macro Q | Free Copy Macro 9
Inputting UserForm data into specific cells 1

Top