لطفا منتظر باشید ...
Implementing Share-Level Security: Establishing a Database Password
The simplest, yet least sophisticated, method of implementing security is to assign a password to the overall database. This means that every person who wants to gain access to the database must enter the same password. After a user gains access to the database, all the database's objects are available to that user. We refer to this type of security as share-level security .Share-level security is the simplest and quickest security to set up. With almost no effort, you can secure the database and its objects. This method of security is quite adequate for a small business in which the administrators of the database want to ensure that no unauthorized people can access the data, but that each authorized person has full access to all its objects.To assign a database password, follow these steps:
Figure 27.1. The Set Database Password dialog box allows you to set a database password.
After you assign a password to a database, Access prompts users for a password each time they open the database. The Password Required dialog box appears each time the users open the database, as Figure 27.2 shows.
Figure 27.2. The Password Required dialog box prompts the user to enter a password.
After users enter a valid password, they gain access to the database and all its objects. In fact, users even can remove the password by choosing Tools, Security, Unset Database Password. The Unset Database Password dialog box only requires that users know the original password (see Figure 27.3).
Figure 27.3. The Unset Database Password dialog box allows you to remove a database password.
Although these passwords are extremely easy to understand and implement, they also are extremely unsophisticated. As you can see, users either have or do not have access to the database, and it is very easy for any user who has access to the database to modify or unset its password.Step 11: Assigning Rights to Users and Groups" section of this chapter.
