Each person accessing the database must have an Oracle userid. While userids are normally created by a DBA, they can be created by anyone who has the CREATE ANY USER system privilege. The usual syntax to create a user is as follows:

CREATE USER username IDENTIFIED BY password
    DEFAULT TABLESPACE default_tablespace_name
    TEMPORARY TABLESPACE temporary_tablespace_name
    QUOTA 10M ON default_tablespace_name
    PROFILE profile_name;

If you do not specify a default tablespace or a temporary tablespace, Oracle will automatically assign the SYSTEM tablespace. However, you must specify a quota for the default tablespace, or the user will still not be able to create any tables or indexes in the default tablespace. You do not need to specify a quota for the temporary tablespace. See Chapter 13, for the complete CREATE USER syntax.