How can the view mechanism be used to control access to data

Assignment Help Database Management System
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?)

Reference no: EM131860974

Questions Cloud

Conducting internal and external analysis : The need for conducting internal and external analysis. What are the advantages and disadvantages of internal and external analysis?
Should the company outsource and why : When the variable cost of outsourcing is $5 per unit, what is the break-even quantity in this case? Should the company outsource? And why?
What is the formula using find and mid : You've been given a list of product IDs. Your client would like you to extract the dash as well as the first letter before the dash and first number
Discuss some of the potential ethical concerns : Discuss some of the potential ethical concerns that relate to these two very different interpretations of the appropriate role of a judge.
How can the view mechanism be used to control access to data : How can the view mechanism be used to control access to data? (What are some of more interesting things you can do with the view mechanism to control access?)
Give a quick list of various companies : Give a quick list of various companies and for two companies discuss some tangible and intangible assets.
Explain what mediated viral communication is : Explain what mediated viral communication is, its role/relationship with businesses, and what impact you believe cloud computing technology
Determine which executive should receive the memo : Write a persuasive memo presenting your recommendations for their business improvement program.
Verifiable evidence when making recommendations : Why is it important to provide clear advice which is supported by verifiable evidence when making recommendations? 75 - 100 words

Reviews

Write a Review

Database Management System Questions & Answers

  What is the cost of joining r and s using a sort-merge join

What is the cost of joining R and S using a page-oriented simple nested loops join? What is the minimum number of buffer pages required for this cost to remain unchanged?

  Explain what fields might be used as keys and indexes.

Describe any limitations or constraints related to the data and how it is structured.

  Develop design employing computer-aided software engineering

For this assignment, you will use Visio Software Application to develop the design employing the following computer-aided software engineering (CASE) modeling tools.

  Knowledge and data warehousing adventure works cycles the

knowledge and data warehousing adventure works cycles the fictitious company on which the adventureworks sample

  Explain why the entity relationship model is useful

Explain why the entity relationship (ER) model is useful. How has it helped to produce a more structured relational database design environment?

  Explain which tables columns keys will be seen in the schema

Using both MySQL Server and MySQL Workbench, create a schema called ABC_YourLastName. Explain which tables, columns, keys, and so on will be seen in the schema

  Compute variable overhead spending variance

Order Up, Inc. provides order fulfillment services for e-commerce merchants. The company maintains warehouses that stock items carried by its clients.

  Describe inventory application with keyboard events

(Inventory Application with Keyboard Events) Enhance the Inventory application that you developed in Tutorial 4 to prevent the user from entering input that is not a number. Use keyboard events to allow the user to press the number keys, the left and..

  What kind of a design would you try in this case

Suppose that your database system has very ine?cient implementations of index structures. What kind of a design would you try in this case?

  Advantages and disadvantages of using data analytics

Analyze the main advantages and disadvantages of using data analytics within the industry or company that you have chosen

  Create a use case diagram for osceolas operations

Use MS Visio to create a use case diagram for question 1, a selected class diagram for question 2, and a sequence diagram for question 3.

  Implement direct-address table keys of stored elements

Suggest how to implement direct-address table in which keys of stored elements don't require to be distinct and elements can have satellite data.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd