This can be accomplished by one of the following two ways:
Modify the dbname property in the display profile for Discussions channel for each role to point to a different database.
In this case users in one role cannot view discussions created by users in a different role.