User profiles and user access levels
You’ll need to develop a user profile for each user in each group. As part of each profile, you’ll assign to the user an access level. Each user’s access level is matched with the table’s privilege scheme (see the next section) to determine what access the user has to the table and, within each table, to each field. For example, if you establish a read privilege of 5 for a table, users with a level from 1 to 5 can read that table. Users with a level of 6 or higher can’t read the table.
By establishing access levels within a group, you can give different users different kinds of access to the table and to fields within the table.
Access levels can range from 1 to 8 (the default is 1). Low numbers give the user greater access; high numbers limit the user’s access. The access value is a relative one—it has no intrinsic meaning.
The less restrictive levels (1, 2, 3) are typically assigned to the fewest people. To limit access to data, the more privileges a level has, the fewer users you should assign to that level.
You can assign any number of users to each access level.
If you don’t need to vary the access level of the users within a group, there is no need to change each user’s default level.