Question

1. Describe one solution about how to create and authenticate the identities of the database administers

2 Describe one solution about how to grant the administrator permissions to the three employees.

Answer 1

1. Authentication means verifying the identity of someone. You must identify your user before you can determine their privileges and access rights, and so that you can audit their actions upon the data.

We can authenticate the identities of the database in a number of different ways. In the database, you can do this such as the database performs both identification and authentication of users.

Passwords for Authentication

Passwords are one of the basic forms of authentication. A user must provide the correct password when establishing a connection to prevent unauthorized use of the database. Otherwise, he or she can't access the data.

Passwords are assigned when users are created. A database can store a user's password in the data dictionary in an encrypted format. Users can change their passwords at any time

2. Permissions are also applied to secured objects, such as files and folders, Active Directory objects, services, or registry objects. Permissions can be granted to a user, group, or computer. Two types of privilege are;

a. Automatic privilege. For example, after logging in to a system, logging out won’t require a privilege.

b.Granted privileges usually accomplished by logging onto a system with a username and password.