Joined WorkGroup Issues

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I developed two databases and now I want to join them together using the same
workgroup. The workgroup names are as follow: ApplicationUsers (ReadWrite),
ReadOnlyUsers. The problem is that a user in database A has applicationUsers
permission but that same user only has ReadOnlyUsers permission in database
B. Since they are joined by the same workgroup, whatever permission I
granted the user in database B will effect the user in database A.

I don't want to create two separate workgroup this. How would you handle
this situation. Please help.
 
boardrider said:
I developed two databases and now I want to join them together using the same
workgroup. The workgroup names are as follow: ApplicationUsers (ReadWrite),
ReadOnlyUsers. The problem is that a user in database A has applicationUsers
permission but that same user only has ReadOnlyUsers permission in database
B. Since they are joined by the same workgroup, whatever permission I
granted the user in database B will effect the user in database A.

I don't want to create two separate workgroup this. How would you handle
this situation. Please help.
Click to expand...

You need more groups. Groups need to be defined "per app", not per workgroup
file.
 
You need to grant permissions by GROUP, not by the USER. If USER1 is a
member of ApplicationUsers, then USER1 will have all the permissions for
that group. To deal with the separate databases, you will probably need an
ApplicationUsers_A and an ApplicationUsers_B and same thing for the Read
Only users. Keep in mind that a user can be a member of more than one group
and will get the least restrictive permissions of all the Groups that user
is a member of.
 
Back
Top