Table access
First, you’ll need to define user groups and determine which group has access to which table. Try to organize users and tables into groups that reflect application use (for example, by department or sales area).
A table can be assigned to only one group. If the user group and table group don’t match, the user can’t access the table.
Typically, each group is associated with a set of tables. By associating each application with its own group, you can use the group to control data access.
A user can belong to more than one group. However, each group that a user belongs to must be logged-in separately.
If a user needs to access tables from two different groups in the same session, the user must log out of one group, then log in to the second. A user may have separate logins into different groups in separate sessions to access files in different groups.