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

Chapter 12. Managing a Database > Setting User and Group Permissions

Setting User and Group Permissions

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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