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

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