This week’s session covers the degrees of granularity that can be used to contro

Question

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

Explanation / Answer

View For Control Access to Data:

Hence, this is how views can add to the user functionalities while access the control access to the end users.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.