Question: Imagine that you have successfully completed a DBA course. Now you are hired as a database security expert to train the database administration team. At

Imagine that you have successfully completed a DBA course. Now you are 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 SQL*Plus. Write the query and show the output for the following steps (as sys or system): a. Create a user named CH0306 with the same password. Use all default values for the user options. b. Modify the user options to change the default tablespace to TOOLS. (Note: You need to create a TOOLS tablespace before you answer this question.) c. Lock the CH0306 account. d. Change the CH0306 user password to DBSEC. e. Query the CH0306 account using the data dictionary view DBA_USERS. f. Query the CH0306 users quotas using the data dictionary view DBA_TS_QUOTAS. g. Provide unlimited storage quotas to CH0306 on TOOLS and USERS.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

31.25 pts A retail tenant pays percentage rent of 3% over a natural breakpoint based upon a rental rate of $10 per square foot. The tenant leases 4,000 square feet and is estimated to generate...

PROJECT SCOPE [Instructions for what to include in this section: Define the scope of work that will be undertaken to provide the deliverable(s) mentioned in the Project Charter (PC). Craft this...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

Assessment Task 2 Develop workplace policies and procedures for sustainability BSBSUS511 Student Declaration To be filled out and submitted with assessment responses I declare that this task and any...

The Industrial\\Organizational Program Handbook Florida Tech 2013-2014 Rev: 7/31/13 Welcome to the Industrial/Organizational Psychology program at Florida Tech! We are glad you have chosen Florida...

Case Study: KALCH Distribution Company (KDC) Overview KDC is a regional transportation and distribution company in operation for over 60 years. The company serves major cities in the Mid-Atlantic...

Please read: The chapter is too long and i really cannot send it via here. can you suggest any other way to sent the chapter 3. Learning objectives or competencies covered by the course and a...

FIJI REVENUE & CUSTOMS AUTHORITY 2015 ANNUAL REPORT I MANAGEMENT REPORT 01 Board of Directors 4 02 FRCA Management Team 5 03 Chief Executive Officer's Report 6 II CRITICAL SUCCESS FACTORS 2015 01...

CIS 620/B Project Plan For the Global Collaboration Enterprise Information System 1200 12th Avenue, Suite 1200 Seattle, Washington 98114 U.S.A. November 11, 2015 Draft Version 19.0 November 11, 2015...

Repeat parts (a) and (b) in Problem 1 assuming Kaelea has a tax rate of 35 percent.

Bob, an engineer, decided to start a college fund for his son. Bob will deposit a series of equal, semiannual cash flows with each deposit equal to $1500. Bob made the first deposit on July 1, 1998...

what is a companys sales mix break even in units number of units to produce to make a certain profit proportion of each product that makes up the companys total sales total amount of a company's sales

Weighted Average Method, Unit Cost, Valuing Inventories Cassien Inc. manufactures products that pass through two or more processes. During June, equivalent units were computed using the weighted...

True or False? An increase in the American dollar price of the South Korean won implies that the South Korean won has depreciated in value. Explain.

KEY QUESTION Suppose in Fiscalville there is no tax on the first $10,000 of income, but a 20 percent tax on earnings between $10,000 and $20,000 and a 30 percent tax on income between $20,000 and...

KEY QUESTION What effect will each of the following have on the supply of auto tires? a. A technological advance in the methods of producing tires. b. A decline in the number of firms in the tire...