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

  Designing and documenting your system

Create a document named: surnameStudentIDAssign1.doc .  In your document, you must include the following section headings:  System Overview, Class Diagram, Class Descriptions, Testing.

  Discuss the reasons for converting sql queries into

1. what a query execution plan?2. discuss the reasons for converting sql queries into relational algebra queries before

  Build the prototype as a distributed system

You should document a UML design for the proposed system. This should include a description of: architecture, requirements and functionality, detailed system design.

  Provide a description of relationships between organisation

Discuss how this organisation has responded to the introduction of Information Systems (IS) into their business paradigms. Highlight the advantages of IS, the disadvantages and the resultant shortfalls that must be addressed in this organisation.

  Compile a list of five system administration

Compile a list of five system administration best practices for any two operating systems.

  Questionethical and legal considerations in marketing

questionethical and legal considerations in marketing intellectual property and product safetyprepare a paper in which

  Explain components represented in cell using mccumber model

Suppose that the security model is required for protection of information in class. Using NSTISSC model, analyze each of cells (i.e. 27 cells related with McCumber model).

  Discuss the costs involved in implementing the database

Using the SafeAssign link in Blackboard to submit your report. Download and print out the FULL report and attach to the appendix at the back of your report. Assignments without the full SafeAssign report will NOT be marked.

  Explain thoughts on database design process

Explain thoughts on database design process this far. You have learned about first three phases of process: defining mission statement and mission objectives, analyzing current database, and creating data structures.

  What are the responsibilities of a dba

What are the responsibilities of a DBA? If we assume that the DBA is never interested in running his or her own queries, does the DBA still need to understand query optimization? Why?

  Defines the semantic checks necessary to produce

The third project involves writing the semantic analyzer for the compiler that was begun in the previous projects. To simplify the semantic error checking, you are to remove the ability to have multiple functions from the grammar and the ability t..

  Prove that armstrongs axioms are sound and complete for fd

Prove that Armstrong’s Axioms are sound and complete for FD in-ference. That is, show that repeated application of these axioms on aset F of FDs produces exactly the dependencies in F+.

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