General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>Our database system requires a hierarchy of users like so:
A
/ \
B C
/ \ / \
d e f g
/\
h i
User B can see/edit records allocated to B, d, e, h and i, but cant see any others. User d can see records allocated to them, h and i only, and so on.
How would you set this up in a database? <<
How about a simple "user level" 1-9
Any user can edit records where the user=himself or the userlevel
so A=level 9, B,C=level 8, defg=level 7, hi=level 6 and so on?
Gary.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only