• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 24. Securing Multiuser Network A... > Granting and Revoking Permissions fo...

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, but you cannot revoke permissions that individual members inherit from the group. Permissions are stored within the database file as properties of individual database objects. Only members of the Admins group or users who have Administer permission can grant or revoke permissions for database objects.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint