Joined WorkGroup Issues

[boardrider]

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.

 

[Rick Brandt]

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.

You need more groups. Groups need to be defined "per app", not per workgroup
file.

 

[Lynn Trapp]

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.