You were just hired as a new junior Oracle database administrator to assist a te

Question

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.

Explanation / Answer

//if you have any query then comment below.please rate the answer

Answer:

Steps for doing this: You have to create the TEMP tablespace once to be used as a default temporary tablespace for users.
SQL> CREATE TEMPORARY TABLESPACE TEMP
2 /
Tablespace created.

Step 2: initialization parameter DB_CREATE_FILE_DEST to the location where the Oracle datafiles reside.
Template script: Save the following script to a file and run it from SQL*Plus like this @script_name

Step 3:- write a script :-

CREATE USER &USERNAME IDENTIFIED BY &PASSWORD DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP ACCOUNT LOCK PROFILE DEFAULT QUOTA 10M ON USERS
/

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.