1 / 9

Security Dalam Aplikasi Pertemuan 17

Security Dalam Aplikasi Pertemuan 17. Matakuliah : F0654/Lab Sistem Informasi Akuntansi Tahun : 2007. Microsoft Access Database Security - Security Permissions:. Permissions

ida
Download Presentation

Security Dalam Aplikasi Pertemuan 17

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Security Dalam Aplikasi Pertemuan 17 Matakuliah : F0654/Lab Sistem Informasi Akuntansi Tahun : 2007

  2. Microsoft Access Database Security - Security Permissions: Permissions • After you run the Security Wizard, you can manually change database and object permissions for user and group accounts in a workgroup. It's advisable to assign permissions to groups, not to users, because each user inherits the permissions assigned to the group.

  3. Microsoft Access Database Security - Security Permissions: Permission Types • Each user has access to nine types of permission for data or objects in a database. The following table describes the nine types of permission, and what each type enables a user to do. To read more about these permissions, search Microsoft Access Help for permissions, display the topic Work With Permissions, and select Types Of Permissions.

  4. Granting permissions to a database and its objects • Choose Tools, Security, User And Group Permissions to display the User And Group Permissions dialog box. • Select the Change Owner tab. Select different object types and notice that you are the current owner of the database and all its objects

  5. 3. Select the Permissions tab. Let's take a look at the permissions assigned to the users and groups, starting with the groups. 4. From the List options, select Groups. The Admins group is selected in the User/Group Name list.

  6. 5. Explore the permissions assigned to various object types and group names. Notice that the Order Entry, Sales Managers and Users groups have no permissions assigned to them. For the Users group, you want to leave it set that way. 6. From the User/Group Name list, select Order Entry. You want to assign permissions to this group. 7. From the Object Type drop-down list, select Database. In the Permissions section, check Open/Run

  7. 8. Click Apply. All users in the Order Entry group have permission to open and run the current database. 9. Now let's set the Order Entry group's permissions for the table objects in the current database. From the Object Type drop-down list, select Table. From the Object Name list, select all the table names. 10. In the Permissions section, check Update Data and Insert Data. Uncheck Delete Data. Notice that the options Read Design and Read Data are also checked by default with these options. Three options should be unchecked: Modify Design, Administer, and

  8. Click Apply • Apply database and object permissions to groups according to the specifications in the following table (select all object names for each object type): • Click OK to close dialog box

More Related