Part 1:
Please respond to the following in not more than 250 words:
Identify a database table in a specific business system, and one user (not administrator) role that might need access to that table. Do not repeat an example from the textbook or one that has been posted by another student.
Which of the create, read, update, and delete (CRUD) rights would you grant to that role, and which would you withhold? Why?
Part 2:
In a separate post, follow up on one of your fellow students in substantive posts of up to 200 words that further the discussion. For example, you may support or politely challenge a post with your own insights or experience, make a suggestion, or ask probing follow-up questions.
Support your positions with explanations and/or sources, as appropriate, but do not quote. (choose one)
a. A simple database program has tables that are separate entries you can make to the program. Databases have become very useful way to have computer-based systems to take over from paper-based system. The ability to assign privileges to individual tables allows you to setup security to the systems information.
The searchability of this information has transformed the way we store and recall information. We use a web-based customer database at work to assign ticket numbers, serial numbers of equipment and problem descriptions. All notes about repairs are added along with parts and labor. All workers have create, read, update privileges, only managers can delete charges or modify prices.
They have set this up that way to keep techs from modifying prices and making unauthorized changes to work orders. Say a worker's friend comes in for service and they want to give their friend a break by cutting prices and pocketing the cash. Other examples would be just keeping us out of trouble I like not having these privileges that way I am not responsible for these situations.
b. The database table from a specific business system would be from a used car department in a dealership. The table would contain information on cars that where traded in and the money recieved from that traded in car. Also the table would contain numbers on market value of the car and wholesale value from the car.
The user that would need access to that table would be the used car manager. He is the one that needs the create, read and update rights. The only right he should not have is the delete rights, that should be higher in the food chain.
c. A clothing store would need a database that records inventory, sales, and returns. The store managers would need access to the database to view sales and make adjustments as needed. I would grant the store manager the read and update roles, and I would grant other store personnel read permissions.