Modify the user options to change the default tablespace

Assignment Help Computer Engineering

Reference no: EM131917385

Assignment

Question 1.

You were just hired as a new junior Oracle database administrator to assist a team of five senior database administrators. In your first week, you were handed the task of writing a script as a template for creating database users. The script is to prompt the administrator for a username and password, and the script creates the user according to the following guidelines.

a. The default tablespace is USERS.

b. The temporary tablespace is TEMP

c. The account is initially locked.

d. Expire the password

e. The user account is assigned the DEFAULT profile.

f. Set a 10 MB quota on the USERS tablespace.

Question 2.

Run a query on the DBA_TS_QUOTAS data dictionary view that only displays users

who have used up no storage.

Question 3.

Imagine that you have successfully completed CS674. 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 user's quotas using the data dictionary view DBA_TS_QUOTAS.

g. Provide unlimited storage quotas to CH0306 on TOOLS and USERS.

Reference no: EM131917385

Questions Cloud

Large food epidemics result from these practices : How does this impact our ecosystem and how does situations like mass crop extinction and large food epidemics result from these practices?

Prepare program to meet specifications of companys request : Using Visual Studio and C# programming concepts. Prepare a program to meet the specifications of the company's request.

How much carbon is captured by a square mile : How much carbon is captured by a square mile of Indonesian forest? How long should country B be required to protect that forest for a particular payment?

Why do you believe that such an award is necessary : Do you believe that the jury's award of $2.7 millions for third-degree burns was excessive?

Modify the user options to change the default tablespace : Modify the user options to change the default tablespace to TOOLS. (Note: You need to create a TOOLS tablespace before you answer this question.)

Should dimercurio be required to pursue claim : From time to time courts are called on to determine the enforceability of an arbitration clause contained in a contract. One such case was DiMercurio v. Sphere.

How do you think companies should respond to accusations : What do you think management at Renault should have done about the anonymous accusation about a senior official negotiating a bribe?

Discuss the foreign sovereign immunities act : Zedan received a telephone call from a Saudi Arabian organization offering him an engineering position at a construction project in Saudi Arabia.

Expectations of trader about the future price of stock : what are the expectations of the trader about the future price of the stock if this strategy is implemented?

User Account

All Pages