O'Reilly logo

Special Edition Using Access 97, Second Edition by Roger Jennings

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Granting and Revoking Permissions for Database Objects

The second layer of Access security is at the database level. Access lets the database administrator grant or revoke permissions to use specific database objects to all members of a group or to specific members of a group. Permissions grant authority for users to view or alter specific database objects. The permissions granted to the group are inherited by each member as he or she is added to the group. Thus, it is important that you establish the group permissions you want before adding users to a group.

Users who are members of more than one group, such as Admins and Users, inherit database object permissions from each group. You can grant additional permissions to individual group members, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required