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

  Use the prime minister database

Write SQL SELECT statements to retrieve the following information from the Prime Minister database.

  F does not logically imply

Given R = (J,K,L ) and the set F of FDs J -> K and L -> K , show that F does NOT logically

  Convert the er/eer model

To represent a problem description given in natural language as an (Enhanced) Entity -Relationship model; to convert the ER/EER model into a relational data model;

  Question for database schema

The patient information along with the ID of any prescribing doctor for each patient and the prescription information along with patient name, DOB, medication brand name, and prescribing doctor name sorted by most recent date.

  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.

  Create program to enter first and second number

Create a program that enters first and a second number. The first and second number that will be entered should be computed in halves, quarter, double, and square.

  Strengths and weaknesses of three dbms software

Research Report around 800 words strengths and weaknesses of three DBMS software packages for utilization as a company-wide customer information database. Please compare Microsoft Access, Microsoft SQL Server, and Oracle.

  Add three rows to the downloads

Add three rows to the Downloads table: one row for user 1 and product 2; one for user 2 and product 1; and one for user 2 and product 2. Use the GETDATE function to insert the current date and time into the DownloadDate column.

  Create report using wizard or based on sql query

Create a report using the wizard or based on an SQL query that that shows Courses that instructors are approved to teach. Show Course Number, First Name, and Last Name of Instructor.

  Write a select statement that returns these columns

Write a SELECT statement that returns these columns from the Products table: The date_added column A column that uses the CAST function to return the date_added column with its date only (year, month, and day)

  Write a script that uses two variables

Write a script that uses two variables to store (1) the count of all of the products in the Products table and (2) the average list price for those products. If the product count is greater than or equal to

  Write pl-sql block that displays last name

Write PL/SQL block which displays last name and salary of following people. Each of these can be done separately as PL/SQL, first to test and get output lines.

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