参考资料上有这样的介绍: A Teradata user is a database with an assigned password. 也就是说User也是一种Database, 再看下面的一张图: 看最下面一句话,Database或User必须由User创建我能理解,难道User也能由Database创建吗? 求各位前辈指点,多谢!
找到了以下参考资料:
The Data Dictionary (DD) is an integrated set of system tables that:
• Stores database object definitions and accumulates information about users, databases, resource usage, data demographics, and security rules.
• Records specifications about tables, views, and macros.
• Contains information about ownership, space allocation, accounting, and access rights (privileges) for these objects.
Data Dictionary information is updated automatically during the processing of Teradata SQL data definition language (DDL) statements. It is used by the Parser to obtain information needed to process all Teradata SQL statements.
Users may access the DD through Teradata-supplied views, if permitted by the system administrator.
也就是说Users是被系统自动管理的,创建用户只能在有权限的情况下用CREATE USER实现,当然正常情况下是不能有权限用DB来创建用户的。
多谢各位大侠指点,我有点钻牛角尖了