Describe discretionary access control

Assignment Help Database Management System
Reference no: EM13742303

Part -1:

Case: Training Case

You were hired as a database security expert to train the database administration team. At the first training session,you ask the trainees to perform the following tasks using Oracle Enterprise Manager or SQL*Plus. Describe what you expect your trainees to produce.

• Create a user named CH0306 with the password CH0306.
• Modify the user options using SQL*Plus to change the default tablespace and temporary tablespace to TOOLS and TEMP respectively.
• Lock the account.
• Using SQL*Plus change the user password to DBSEC. (Optional)
• View the account using the data dictionary.(You can provide a screenshot)
• View user quotas using the data dictionary.

At the second training session,you ask the students to outline a list of the best three practices of user administration.List what you expect your students to produce.

Case - Training Case (Modified)

You were hired as a database security expert to train the database administration team.At the first training session,you ask the trainees to perform the following tasks using Microsoft SQL Server Management Studio. Describe what you expect your trainees to produce. (You can use the following help)

• Create a login named CH0306 with the password CH0306.
• Create a database user of the same name for the login created above.
• Change the user password to DBSEC. (Optional)
• View the account using the data dictionary. (You can provide a screenshot)

Part -2:

Please describe DAC (Discretionary Access Control), MAC (Mandatory Access Control), and RBAC (Role-Based Access Control) ?

Reference no: EM13742303

Questions Cloud

Write biology essay about the neck muscle with sports : Write Biology essay about the neck muscle with sports
What was a voting reform present within the new jersey : What was a voting reform present within the New Jersey state constitution of 1776? In 1781, the first written constitution of the United States took effect.
Describe the specific objectives of capacity planning : Describe the specific objectives of capacity planning and how it best supports a company's competitive strategy. Since we have been using a number of computer based models in our class this term, I would like you to put together an example with so..
Create an original model of an essential amino acid : Create an original model of an essential amino acid with side chains. Describe two chemical characteristics (i.e., reactivity, toxicity, flammability, or hydrophobicity) of the amino acid of which you created a model
Describe discretionary access control : Database security expert to train the database administration team.At the first training session,you ask the trainees to perform the following tasks using Microsoft SQL Server Management Studio. Describe what you expect your trainees to produce.
Define operational efficiency and operational effectiveness : You are to succinctly define in your own words the phrases "operational efficiency", "operational effectiveness", "operations strategy" and "operational sustainability" Further, you are to address "Six Sigma," and comment on its applicability and v..
Discuss various applications of genomics and biotechnology : Discuss the various applications of genomics and biotechnology, Examine DNA structure, and function, gene expression, and control
Performance management invalid in relation to morettis job : How was Heinz's approach to performance management invalid in relation to Moretti's job? Explain your answer in relation to significance of strategic performance management, appraisal and employee feedback in organisational context.
Write a paer on genetically modified organisms : Select one of the topics listed below: 1. Genetically modified organisms (GMOs). 2. Stem cells. 3. Fracking (hydraulic fracturing) and tar sands (oil sands)

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

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