This topic describes the schema-level permission model (SLPM) in Hologres.
Hologres is compatible with PostgreSQL and allows you to use the standard PostgreSQL authorization model. For more information, see Standard PostgreSQL authorization model. In the standard PostgreSQL authorization model, permissions are managed in a fine-grained manner. To simplify operations, Hologres provides the following two simple permission models for different business scenarios:
- Simple permission model (SPM): This model allows you to grant a user database-level permissions with ease. For more information, see SPM.
- SLPM: This model divides permissions based on schemas. Compared with the SPM, this
model manages permissions in a more fine-grained manner. If you want to divide permissions
in a strict manner and grant permissions with ease, we recommend that you use this
Note In the Hologres console, you cannot grant a user permissions by using the SLPM. You must connect a Hologres instance to a development tool and execute SQL statements to grant permissions.
User groups and permissions in the SLPM
After you enable the SLPM, the system generates the following user groups with different permissions for each database:
The following table describes the permissions of each user group.
|Superuser||Serves as an administrator of a Hologres instance and has all the permissions on the instance.|