Once you have defined users and groups, you will want to define permissions for them. Permissions indicate the ability of each user or group to modify databases or database objects. Permissions also control a user's ability to create new objects. For example, you might want to limit the ability to view the Salaries table to a small group of users, and limit the ability to edit that table to an even smaller group.
Change Account Permissions
- Start Access, type Admin as the user name, press Tab, and then enter the password for the Admin account.
- Click the Tools menu, point to Security, and then click User And Group Permissions.
- Click the Permissions tab.
- Click the Users option or the Groups option, depending on whether you want to modify the rights of individual users or entire groups.
- Click the name of the person or group for whom you want to change permissions.
- Click the Object Type list arrow, and then select an object type.
- Click the name of an existing object or click <New Object>.
- Select the applicable check boxes to add or remove permissions for the selected object.
- Click Apply.
- Click OK.
Select Permissions
- When you add or remove permissions for a selected object, refer to the Database Permissions table to the right.
Database Permissions
|
Did You Know?
You can set personal identifiers for user accounts. Personal IDs contain between 4 and 20 letters (capitalization matters) or numbers or both. Along with the account name, a personal ID uniquely tags a user or group in a workgroup. Make sure you keep a copy of both the personal ID and account name in a secure location in case you need to retrieve an account that has been accidentally deleted or moved.
You can simplify user permissions. Instead of assigning permissions to each user, assign permissions to groups, and then add users to the appropriate groups.
You can print a list of permissions. Use the Documenter to print a report describing the permissions for each object in the database.
|
