Describe how security can be implemented in the database

Assignment Help Computer Engineering

Reference no: EM132192723

Write 400-600 words that respond to the following questions with your thoughts, ideas, and comments. This will be the foundation for future discussions by your classmates. Be substantive and clear, and use examples to reinforce your ideas:

Databases exist to allow for the easy storage and retrieval of data, but not every user should have access to all data in the database. Your boss has asked you to describe how security can be implemented in the database to protect the sensitive data and allow some users to see certain data while others are restricted from seeing the data. To help understand Database Security mechanisms, provide your input to the following:

Describe Data Control Language, and how the GRANT and REVOKE statement can be used to implement access control.

Describe the function and use of database roles in the implementation of access control.

Describe the public role and how it can eliminate all access control that can be implemented.

Describe how views can be used to enhance the security of data in a database.

Reference no: EM132192723

Questions Cloud

What details will i need to accomplish the goal : This week, you will be changing gears and moving from narrative writing to beginning on the informative paper. For this assignment, please review the directions

Explain about business and intellectual property law : What is the downside of ignoring ergonomics in the work place? Explain about Business and Intellectual Property Law.

What is an intelligence analysis strategy : What is an Intelligence Analysis Strategy and how is it used? How can an Intelligence Analysis Strategy be used on a terrorist organization such as Al Qaeda?

Importance of information technology and systems : The importance of information technology and systems in businesses today. Include at least one (1) real-world industry example where information technology

Describe how security can be implemented in the database : Describe how security can be implemented in the database to protect the sensitive data and allow some users to see certain data.

What is steve jobs role in apple strategic management : What are Apple’s core competencies? How should Apple compete? What is Steve Jobs’ role in Apple’s strategic management.

Describe the different kinds of fraud andthe fraud triangle : Describe the different kinds of fraud andthe Fraud Triangle, an auditor's responsibility to identify and assess fraud.

How the technology of virtualization works : How the technology of virtualization works, along with applications and benefits for business and remote virtual access.

Industry environments that affect apple choice of strategy : What are key forces in the general and industry environments that affect Apple’s choice of strategy?

User Account

All Pages