User manual

Chapter 6 | Protecting databases 147
Creating privilege sets
You can assign each privilege set to one or more accounts.
To create a privilege set:
1. Follow the steps above to display the privilege sets for a file.
2. Click New.
The Edit Privilege Set dialog box appears. By default, each privilege set option is set to its most
restrictive setting.
3. Enter a name and optional description for the privilege set.
4. Define the privileges for the privilege set.
5. Click OK.
After you create the privilege sets that you want, you need to create or edit accounts so that they
use the appropriate privilege sets. For more information, see
“Creating accounts” on page 145.
For more information about creating accounts and privilege sets, see Help.
About enabling record-level access
You can set individual record access for each table. For example, the privilege set can limit the
ability to:
1 View, edit, create, or delete all or certain records within each table.
1 Access or modify certain fields within each table.
You can only set record access privileges for tables defined in the current file. If the file contains
relationships to tables in other files that you want to protect, you need to create accounts and
privilege sets in the other files to protect those tables.
For more information about using the Edit Privilege Set dialog box, see Help.