What Are the Schemas, Users, and Roles in GaussDB?

Answer: A schema is a logical division of a database. All database objects are created under certain schemas. Schemas and users are loosely bound. When you create a user, a schema with the same name as the user will be created automatically. You can also create a schema or specify another schema.

Users and roles are used to control the access to databases. A database may be used by many users, and users are grouped into a database role for easy management. A role can be a database user or a group of database users, depending on role settings. The difference between roles and users is that a role does not have the LOGIN permission by default. In service design, you are advised to use a role to configure permissions rather than accessing databases.