TEMPORARY TABLESPACE
tablespace
The tablespace where temporary segments are created
during sort operations, index creation, and so forth.
QUOTA { size | UNLIMITED } ON
tablespace
The amount of space allowed for objects created on
the specified tablespace. Size is in kilobytes (K) or
megabytes (M).
PROFILE profile The profile assigned to this user. Profiles are discussed
later in this chapter. If a profile is not specified, the
DEFAULT profile is used.
PASSWORD EXPIRE At first logon, the user must change their password.
ACCOUNT {LOCK | UNLOCK} Specifies whether the account is locked or unlocked.
By default, the account is unlocked.
TABLE 9-2 The Options for the CREATE USER Command
Chapter 9: Database Security and Auditing 289
The user SKING is authenticated by the database with an initial password of SKING901. The
second line is not required; all accounts are created unlocked by default. Both the default permanent
tablespace and default temporary tablespace are defined at the database level, so the last two
lines of the command aren??™t required unless you want a different default permanent tablespace
or a different temporary tablespace for the user.
Even though the user SKING has been either explicitly or implicitly assigned a default permanent
tablespace, he cannot create any objects in the database until we provide both a quota and the
rights to create objects in their own schema.
A quota is simply a space limit, by tablespace, for a given user.
Pages:
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488