Teradata数据库Database与用户User的关系

byandong 2014-07-10 04:32:01
参考资料上有这样的介绍:
A Teradata user is a database with an assigned password.
也就是说User也是一种Database,
再看下面的一张图:


看最下面一句话,Database或User必须由User创建我能理解,难道User也能由Database创建吗?
求各位前辈指点,多谢!
...全文
413 3 打赏 收藏 转发到动态 举报
写回复
用AI写文章
3 条回复
切换为时间正序
请发表友善的回复…
发表回复
byandong 2014-07-11
  • 打赏
  • 举报
回复
找到了以下参考资料: 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来创建用户的。 多谢各位大侠指点,我有点钻牛角尖了
AcHerat 元老 2014-07-10
  • 打赏
  • 举报
回复
database是创建不了user的,两者的含义不同,database是存放data的介质,user是操作database system的用户或者说一个使用身份。
Andy-W 2014-07-10
  • 打赏
  • 举报
回复
从图上看,一般的User 是有最User sysdba創建的。 Create User or create db的時候,可以分配永久性空間,或不分配永久性空間。user 與db唯一区别在于一个有密码,一个没密码。
软件简介:RazorSQL 是数据库查询工具、SQL的编辑、数据库管理工具,可以通过ODBC,JDBC连接数据库,已经证实可以使用的数据库种类,达到了29种. RazorSQL is an SQL query tool, database browser, SQL editor, and database administration tool for Windows, Mac OS X, Linux, and Solaris. RazorSQL has been tested on over 29 databases, can connect to databases via either JDBC or ODBC, and includes support for the following databases Enhanced Feature Set Standard Feature Set DB2 Ingres Pervasive Cache Mimer SQL Derby InterBase PostgreSQL Daffodil Netezza Firebird JavaDB SQLite DBASE Paradox FrontBase MS SQL Server SQL Anywhere FileMaker PointBase H2 MySQL Sybase (ASE) Mckoi Solid HSQLDB OpenBase Teradata Microsoft Access Informix Oracle Features * A Database Navigator for browsing database objects. * An SQL Editor for creating SQL queries. * Visual tools for creating, editing, dropping, describing, altering, and viewing tables, views, indexes, and sequences * Visual Tools for creating, editing, dropping, and executing stored procedures, functions, and triggers * A robust programming editor that embeds the powerful EditRocket code editor that supports 20 programming languages including SQL, PL/SQL, TransactSQL, SQL PL, HTML, XML, and more. * Export Tool - Export data in various formats * Import Tool - Import data from delimited files, Excel files, or fixed width files into tables * Ships with a built-in relational database engine (HSQLDB) that is up and running out of the box and requires no end-user administration * A Generate DDL Tool for generating table, view, and index DDL. * Table / SQL Query Compare tool for comparing tables or queries across multiple connections * Database Data Search tool for searching single or multiple database table and view data. * Database Object Search tool for searching for database objects. * Backup tools such as the Database Backup Tool and Table Backup Tool * Auto column and auto table lookup * SQL Formatter * SQL Query builder tool * SQL Query Scheduler tool * Command Line Interface * PHP Bridges for connecting to MySQL, PostgreSQL, and SQL Server databases remotely via PHP enabled web servers * An ASP bridge for connecting to MS SQL Server databases remotely via ASP enabled web servers * SQL GUI Tools for generating SQL for various operations * Edit, delete, and insert database data with the Database Editor * Works with all major operating systems including Windows, Mac OS X, Linux, Solaris, and any other Java enabled OS * Tested with Apache Derby / JavaDB, Daffodil DB, DB2, DBASE, Firebird, FrontBase, H2, HSQLDB, Informix, Ingres, Interbase, Mckoi, Microsoft Access, Microsoft SQL Server, Mimer SQL, MySQL, Netezza, OpenBase, Oracle, Pervasive, Pointbase, PostgreSQL, Solid, SQLite, Sybase Adaptive Server Enterprise, Sybase SQL Anywhere, and Teradata

34,576

社区成员

发帖
与我相关
我的任务
社区描述
MS-SQL Server相关内容讨论专区
社区管理员
  • 基础类社区
  • 二月十六
  • 卖水果的net
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧