You should document task and procedure to provide a paper trail for retracing exactly what happened when a breach of security occurs and to ensure administration consistency.

The CREATE USER statement enables database administrators to create a database user account.

The IDENTIFIED clause instructs Oracle 10g on how to authenticate a user account.

There are three methods of authentication available in oracle 10g: the BY PASSWORD option, the EXTERNALLY option, and the GLOBALLY as external_name option.

In Oracle10g, the DEFAULT TABLESPACE clause of the CREATE USER statement specifies the default storage for the user.

The TEMPORARY TABLESPACE clause of the CREATE USER statement takes two options: the name of temporary tablespace or the name of a temporary tablespace group.

The QUOTA clause of the CREATE USER statement informs Oracle of how much storage space a user is allowed for a specified tablespace.

The PROFILE clause of the CREATE USER statement indicates the profile used for limiting database resources and enforcing password policies.

The PASSWORD EXPIRE clause of the CREATE USER statement tells Oracle to prompt the user to enter a new password.

The ACCOUNT clause of the CREATE USER statement tells Oracle whether or not to disable or enable an account.