We have moved to www.dataGenX.net, Keep Learning with us.

Wednesday, July 03, 2013

Teradata Users



 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