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

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

  Create a stack of single byte entities

Write in assembler a program that will create a stack of single byte entities and have the following operations: push and pop.

  Assume that a student table in a university database has an

assume that a student table in a university database has an index on studentid the primary key. and additional indexes

  Explain relational database design

How would you change the current design and how does your new design address the problems you have identified with the current design.

  Write select statement that returns three columns

Write a SELECT statement that returns three columns: InvoiceTotal From the Invoices table, 10% 10% of the value of InvoiceTotal.

  Part 1 - reportwrite a 2000-word report that describes a

part 1 - reportwrite a 2000-word report that describes a suitable methodology from the literature for the purpose of

  Address what makes database connectivity so complex

Address what makes database connectivity so complex and what could be done to simplify it.

  Selecting opies of book titled the big magic

How many copies of the book titled „The big magic? are owned by the local library whose name is "Newtown" library?

  Question 1 for each of the following tasks youll use the

question 1 for each of the following tasks youll use the xxxxxxxx database. you need only provide the query or command

  Sketch object-oriented model for private airport database

Sketch an object-oriented model for a small private airport database that is used to keep track of airplanes, their owners, airport employees, and pilots.

  Part-1therearefourtraininginputtargetpairsforatwo-classprobl

part-1therearefourtraininginputtargetpairsforatwo-classproblema two-input perceptron with hard limit activation

  Convert er diagram into relational schema

Suppose we are to design a registrar's database to store information about students, courses, the courses students have taken. Convert the E/R diagram into a relational schema.

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