- A user or database in Teradata is uniquely named permanent space that can store objects like tables, indexes, procedures, triggers, functions and other databases and users.
- Views, macros, roles and profiles do not consume space, but their definitions are stored in the data dictionary
- A database is repository for database objects, privilege definitions and space limits.
- A user is same as a database except it can logon to Teradata Database with password, establish session and submit requests.
Users vs. Databases
| User | Database |
| A user performs action | Database is passive |
| Users have passwords and startup strings | Databases do not |
| Users can log on to the Teradata Database, establish sessions and submit SQL statements | Databases cannot |
The maximum number of databases and users allowed on Teradata Database is 4.2x109
Print
0 comments:
Post a Comment