How user, database and schema are related in Teradata?

Question

I am aware of Oracle. In oracle schema or user is more or less same. When we create a user, schema is created.

Database is something we create when we install oracle.

I am new to Teradata. Are things same in case of Teradata too?

How user, database and schema are related in Teradata?

score 5 · Accepted Answer · answered Apr 15 '16 at 10:18

5

The full Teradata system is quite similar to a database in Oracle.

A database in Teradata is the same as a schema in Oracle.

A user is almost the same as a database in Teradata ( you can create objects in both), the main difference is the ability to logon to the system.

And there's a hierarchy of users & databases in Teradata, root is user dbc. Users might own databases and databases might own users. A user has the implicit right to manage his children (i.e. GRANT & REVOKE access rights on owned databases & users).

End users are usually a leaf in the hierarchy, no children & no perm space to store tables.

For more details see: About Databases and Users in Teradata

answered Apr 15 '16 at 10:18

dnoeth

59,503
4
39
56

and dnoeth what about schema in teradata? – Dev Apr 15 '16 at 10:28
3

@devツ: Theres no `schema` in Teradata, the closest you get is a `database`. – dnoeth Apr 15 '16 at 11:05
Hi @dnoeth, in nowadays it exist? see https://teradata.github.io/presto/docs/0.167-t/sql/create-schema.html – Peter Krauss Jan 25 '21 at 21:15
2

@PeterKrauss: No, your link is for Presto, not Teradata. – dnoeth Jan 25 '21 at 23:01

How user, database and schema are related in Teradata?

1 Answers1