Reference no: EM131860974

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