In Teradata, a user is the same as a
database with one exception. A user is able to logon to the system and a
database cannot. Therefore, to authenticate the user, a password must be
established. The password is normally established at the same time that the
CREATE USER statement is executed.
The password can also be changed using a
MODIFY USER command.
Like a database, a user area can
contain database objects (tables, views, macros and triggers). A user can have
PERM and TEMP space and can also have spool space. On the other hand, a user
might not have any of these types of space, exactly the same as a database.
The biggest difference between a
database and a user is that a user must have a password. This similarity
between the two makes administering the system easier and allows for default
values that all databases and users can inherit.
The next two lists regard the
creation and modification of databases and users.
{ CREATE | MODIFY } DATABASE or USER
(in common)
- PERMANENT
- TEMPORARY
- SPOOL
- ACCOUNT
- FALLBACK
- JOURNAL
- DEFAULT JOURNAL
{ CREATE | MODIFY } USER (only)
- PASSWORD
- STARTUP
- DEFAULT DATABASE