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.