Discussion: Database Security
Each questions must have 500 words.
APA format with references for each question
The Use of the View Mechanism to Control Access
This week's session covers the degrees of granularity that can be used to control access to data. We can control access to the system, to the server, to the database, to specific columns, and to specific rows. We can also control access by privilege
Read, Write, and Execute or in Oracle Select, Insert, Update, Delete, and Execute. the view mechanism can be used in some interesting way to control access.
Discussion Question:
1. How can the view mechanism be used to control access to data? (What are some of the more interesting things you can do with the view mechanism to control access?)