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

Previous Q& A

  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)

  Explain the differences between management and leadership

Explain the differences between management and leadership, and how cultivating leadership skills in managers can benefit the organization.

  What is maoism and what is the mass line

What is Maoism and what is the Mass Line?What role did they play in the Second Sino-Japanese War, the Civil War, the 1950s' Mass Political Campaigns, the Great Leap Forward, and the Cultural Revolution?

  Explain how cdks regulate cell division

Explain how CDKs regulate cell division, Explain the role of transposable elements in eukaryotes. Using the following DNA template strand sequence, answer the What is the mRNA sequence

  Create a corporate policy designed to minimize inventory

Create a corporate policy designed to minimize inventory shrinkage related to theft, stocking errors, shipping errors, etc., indicating how the policy will be enforced and procedures that may need to be implemented.

  Investigate and evaluate the current leadership strategy

Research into a company that you have chosen to analyse, outline, investigate and evaluate the current leadership strategy that the company is using to achieve its key strategic goals.

  Controlling and managing information

Examine three (3) tools, methods, or techniques that your organization or a company with which you are familiar uses to manage and share communications.

Reviews

Write a Review

 

Similar Q& A

  Create a report which identifies five most expensive bicycle

Create a report which identifies five most expensive bicycles. The report must list bicycles in descending order from most expensive to lease expensive, the quantity on hand for each, and the markup percentage for each.

  Number of employees at the new book sales corporation

To identify the number of employees at the New Book Sales Corporation, you view the records in the Sales Department table.

  What is the functionality of the tool

What is the functionality of the tool and what is the actual running environment (software and hardware) of the tool - how will you evaluate the tool based on your own experience?

  Based on the schema write sql statements

Based on the schema write SQL statements and provide the equivalent relational algebra expressions - relational algebra expressions return and give the equivalent SQL statements.

  Problem on relational algebra

The database used for this question is a very simple one with the following schema: (Primary keys are bold, foreign keys are underlined)

  An art museum that needs to track the artwork artists and

write a 750- to 1050-word paper in which you complete the followingmiddot choose a database environment from the

  How much supervisory wages and factory supplies

How much supervisory wages and factory supplies cost would NOT be assigned to products using the activity-based costing system - How much supervisory wages and factory supplies cost would be assigned to the Batch Processing activity cost pool?

  Define set of relational schemas and identify primary keys

We want to construct a database for a world-wide package delivery company. Define a set of relational schemas and identify primary and foreign keys. Try not to include redundant schemas.

  Relations of airline flight information

The relations given below keep track of airline flight information:Flights(flno: integer, from: string, to: string, distance:integer, departs: time, arrives: time, price: real)Aircraft(aid: integer, aflame: string, cruisingrange: integer)

  Interface with some other dbms

Develop a RDBMS (Relational Database Management System) in Python. The RDBMS should actually be written in Python, not just interface with some other DBMS. This system should track students: Personal Data, Schedules and Grades. The system should cont..

  Identify the data analytics tasks

Provide a clear statement of the aims and objectives of the data analytics study and the possible outcomes in terms of discovered knowledge and its potential application towards solution of the problem. In this section you need to discuss the busi..

  Consider a video game store for each game the

consider a video game store. for each game the databasenbspcontains information aboutnbsptitle producing company name

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