User Account

All Pages

What does each allow or restrict

Assignment Help PL-SQL Programming
Reference no: EM13317563

Objectives:

·To become familiar with basic tasks of user management and how to execute them in Oracle 11g.

·Related to Objectives #3 and #4 as listed in the Syllabus Addendum.

Scenario:
Before coming to CKDS the management of Team Retail, Inc. hired Fly By Night, LLC to build and manage the database. The staff at Fly By

Night designed the database but did not complete the implementation of the design. CKDS has agreed to complete the implementation of the database so Team Retail can use the applications that depend on the database. Redesign of the database will be limited to the tasks required to enable it to function efficiently with a complete redesign following once the needs of Team Retail are more clearly identified.
Now that you have explored Oracle 11g and the Team Retail environment, the CEO of CKDS has some initialization tasks for you. The first task is to identify the user groups and create appropriate sample users.

User management is considered an aspect of security for an Oracle database. The Concepts manual has overview information with detailed instructions for creating users in the Security Guide and 2 Day + Security tutorial.

The CEO of CKDS has observed that user management is simpler and more efficient with the definition and enforcement of a good naming convention and the use of roles and profiles when creating user accounts. Complete each of the following to begin building the user management strategy for Team Retail.

1. Roles and Profiles are used by Oracle to define and control access and privileges of groups of users. Compare and contrast the concepts of role and profile.

a.What is the purpose of each?

b.What does each allow or restrict?

c.How can they be assigned to a user account?

2. Team Retail has decided to have three user groups in addition to the DBAs at CKDS. Those groups are developers, staff, and end-users. The developers will create and manage the applications while the staff will use the applications to accomplish their job duties. The end-users are the customers who will purchase items from Team Retail. Describe/define the access needs of each user group. Consider the following in your answer.

a.What tables will be accessed by each group?
b.What operations will the members need to perform on each table accessed: insert, delete, update, read?
c.What other restrictions or privileges will each group need?

4. Because security and compliance are important considerations for any company, we must include them as we build our database systems. One important and useful contribution of the DBA is to define a naming convention for all users. This convention must provide a unique name for each user and include identification of the user group to which each individual user belongs. Define the naming convention you will use for developers and end-users.

Reference no: EM13317563

Questions Cloud

Handout on legal reasoning and writing : In answering the question, follow carefully the principles set out in the class handout, "Handout on Legal Reasoning and Writing," and subsequently discussed in class.
What would be the height of the atmosphere : What would be the height of the atmosphere if the air density were uniform and decreased linearly to zero with height
What has been the percentage change in price : Consider a 12-year, 12 percent annual coupon bond with a required return of 10 percent. The bond has a face value of $1,000.
Why is convexity a desirable feature to capture in : In general, what changes have occurred in the financial markets that would allow financial institutions to restructure their balance sheets more rapidly and efficiently to meet desired goals?
What does each allow or restrict : Roles and Profiles are used by Oracle to define and control access and privileges of groups of users. Compare and contrast the concepts of role and profile.
What was the duration gap of hands insurance company after : If the interest rate prediction had been available during the time period in which the loan and the liability were being negotiated, what suggestions would you have offered to reduce the possible effect on the equity of the company? What are the diff..
Express the approximate alkalinity of the water : A water sample has bucarbonate concentration of 220 mg/l ( HCO3- )and the PH of the water is 7.9 > Express the approximate alkalinity of this water as mg/l of CaCO3
What is the leverage adjusted duration gap of financial : Verify your answer to part (c) by calculating the change in the market value of equity assuming that the relative change in all market interest rates is an increase of 30 basis points.
What is the rate at which water flows out : A cylindrical tank with a large diameter is filled with water to a depth D = 0.298 m. What is the rate at which water flows out

Reviews

Write a Review

PL-SQL Programming Questions & Answers

  Write sql statement which creates stored procedure

Write SQL statement which creates stored procedure with one int input parameter. Stored procedure selects supplierId field and total of all Count field values for each group of supplierId's from Part table.

  Script that creates and calls a function

Write a script that creates and calls a function named fnItemTotal that calculates the total amount of an item in the OrderItems table (discount price multiplied by quantity)

  Table called transactionlog

Create a table called TransactionLog. Create a trigger, which inserts a new record (user CardNo, ISBN, date) into the TransactionLog table whenever the a borrower checks out a book or returns a book.

  Write sql statement to produce single column

Write an SQL statement to produce a single column called ItemLocation that combines the SKU_Description,the phrase "is located in."

  Write a perl subroutine for temperature conversion

Write a perl subroutine for temperature conversion named ' convert_temp '. It should be able to handle both Fahrenheit to Celsius conversions as well as Celsius to Fahrenheit conversions.

  Create a new database in sql server and run

Create a new database in SQL Server and run the following CREATE TABLE commands. Note that you must run the CREATE TABLE statements in the order presented (and load the data in the order presented) to avoid conflicts resulting from foreign key con..

  Write queries in sql if employee works on every project

Write the following queries in SQL: If an employee works on every project located in Houston, then list the employees social security number and name.

  Create report to display scr courses in alphabetical order

Create the detail report which will display all SCR courses in alphabetical order, with a course name and instructor name in the group header.

  Writing and execuinge sql command

The table name will be METALS and will be used to store description of various metals. Following offers some additional direction on how table must be created.

  Provide a comprehensive record of using sql

Learning Objectives: The purpose of Project 3 is to enable the students to gain extensive experience with using SQL to design and query databases.

  Pretend that you are on the boards

Pretend that you are on the boards of the American National Standards Institute (ANSI) and the International Organization for Standards (ISO), two of the organizations who standardized SQL

  Provide sql statements to create the database

Provide SQL statements to create the database and populate it with sample data (at least four rows per table).

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd