找到了以下参考资料: 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来创建用户的。 多谢各位大侠指点,我有点钻牛角尖了
Create User or create db的時候,可以分配永久性空間,或不分配永久性空間。user 與db唯一区别在于一个有密码,一个没密码。
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来创建用户的。
多谢各位大侠指点,我有点钻牛角尖了