Database Security

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 user name and password, and the script creates the user according to the following guidelines:
a. The default tablespace is TOOLS.
b. The temporary tablespace is TEMP_TOOL_GROUP.
c. The account is initially locked.
d. The user account will be assigned to the DEFAULT profile.
e. The TOOLS tablespace has a 10 MB quota.

2. Outline the steps to create a database user account.

3. What procedures would you follow if you were told that an employee was terminated?