Leave a Reply

The Use of the View Mechanism to Control Access

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. As you have seen in lab assignment 2 (or are beginning to see, depending on where yor are in the completion of the assignment 🙂 the view mechanism can be used in some interesting way to control access.

Discussion Question:

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?) 

Leave a Reply