Accounting Information Systems 9th Edition by James Hall

Exercise 43

DATABASE AUTHORIZATION TABLE
Some relevant database tables and attributes are presented in the figure designated Problem 12 on the following page.
Required
a. Create a database authorization table for an Accounts Payable clerk. Structure your response similar to the example below:

Indicate the name of each table the AP clerk may access and the degree of access privilege as defined below: Read existing records in the table Insert new record into the table, Modify or edit existing records in the table Delete existing attribute values or entire records from the table
b. Explain your answers to part (a) above.