greenplum介绍之数据库管理(四)-创建数据库和用户管理（Greenplum introduces database management (four) - creating databases and user management）.doc

下载文档 降价啦

7
0
约6.83千字
约 11页
2017-08-31 发布于河南
举报
版权申诉
保障服务

greenplum介绍之数据库管理(四)-创建数据库和用户管理（Greenplum introduces database management (four) - creating databases and user management）.doc

1、本文档共11页，可阅读全部内容。
2、原创力文档（book118）网站文档一经付费（服务费），不意味着购买了该文档的版权，仅供个人/单位学习、研究之用，不得用于商业用途，未经授权，严禁复制、发行、汇编、翻译或者网络传播等，侵权必究。
3、本站所有内容均由合作方或网友上传，本站不对文档的完整性、权威性及其观点立场正确性做任何保证或承诺！文档内容仅供研究参考，付费前请自行鉴别。如您付费，意味着您自己接受本站规则且自行承担风险，本站不退款、不进行额外附加服务；查看《如何避免下载的几个坑》。如果您已付费下载过本站文档，您可以点击这里二次下载。
4、如文档侵犯商业秘密、侵犯著作权、侵犯人身权等，请点击“版权申诉”（推荐），也可以打举报电话：400-050-0827(电话支持时间：9:00-18:30)。

greenplum介绍之数据库管理(四)-创建数据库和用户管理（Greenplum introduces database management (four) - creating databases and user management）

greenplum介绍之数据库管理(四)-创建数据库和用户管理（Greenplum introduces database management (four) - creating databases and user management） GREENPLUM introduces database management (four) - creating databases and user management Previous / next 2011-04-08 15:09:01 / personal category: GREENPLUM View (82) / comment (1) / score (5 / 0) GREENPLUM, like ORACLE, has a user management system that is completely independent of the operating system, and a rights management system. First of all, lets introduce the database in GP. After the GP initializes the system, GP automatically creates three databases, postgre, template0, and template1. Where postgre is used as the storage of data within the system, we do not delete it or modify it. Template1 is the default data for the system, and when we create a database, we can create a new database using template1 as a template. So, if you dont want other databases to inherit objects, dont create them in the database template1. The syntax for creating a database in GP is very simple, syntax follows CREATE, DATABASE, newname, USING, TEMPLATE, tmplatedbname; Very fast, and in the process, the system generates the corresponding dictionary information. If the using template clause is not specified, the system creates the new database using the template1 database as a template. We can also create a new database for other templates for other databases. The template0 database is a template for creating template1, and generally we dont use it to create application objects. GP allows you to create multiple DATABASE in a GP SERVER. But a DATABASE can only belong to a SERVER. A connection can only access one database at the same time point. SCHEMA also has the concept of GP. SCHEMA is essentially a collection of relational objects in a database, or can be understood as namespaces of objects. GP allows you to create multiple SCHEMA in one database, but a SCHEMA can only belong to one database. When you create a database, the system automatically creates a SCHEMA