Compatible with PostgreSQL, Hologres allows you to use standard PostgreSQL syntax for data development.
The following table describes the permission query functions supported by Hologres.
The functions supported by Hologres are only a subset of the PostgreSQL functions. For more information about how to use these functions, see System Information Functions in the PostgreSQL documentation.
| Function | Description |
|---|---|
| has_any_column_privilege(user, table, privilege) | Checks whether a specified user can access all columns of a table in a particular way. |
| has_any_column_privilege(table, privilege) | Checks whether the current user can access all columns of a table in a particular way. |
| has_column_privilege(user, table, column, privilege) | Checks whether a specified user can access a column in a particular way. |
| has_column_privilege(table, column, privilege) | Checks whether the current user can access a column in a particular way. |
| has_database_privilege(user, database, privilege) | Checks whether a specified user can access a database in a particular way. |
| has_database_privilege(database, privilege) | Checks whether the current user can access a database in a particular way. |
| has_foreign_data_wrapper_privilege(user, fdw, privilege) | Checks whether a specified user can access a foreign-data wrapper in a particular way. |
| has_foreign_data_wrapper_privilege(fdw, privilege) | Checks whether the current user can access a foreign-data wrapper in a particular way. |
| has_function_privilege(user, function, privilege) | Checks whether a specified user can access a function in a particular way. |
| has_function_privilege(function, privilege) | Checks whether the current user can access a function in a particular way. |
| has_language_privilege(user, language, privilege) | Checks whether a specified user can access a language in a particular way. |
| has_language_privilege(language, privilege) | Checks whether the current user can access a language in a particular way. |
| has_schema_privilege(user, schema, privilege) | Checks whether a specified user can access a schema in a particular way. |
| has_schema_privilege(schema, privilege) | Checks whether the current user can access a schema in a particular way. |
| has_server_privilege(user, server, privilege) | Checks whether a specified user can access a foreign server in a particular way. |
| has_server_privilege(server, privilege) | Checks whether the current user can access a foreign server in a particular way. |
| has_table_privilege(user, table, privilege) | Checks whether a specified user can access a table in a particular way. |
| has_table_privilege(table, privilege) | Checks whether the current user can access a table in a particular way. |
| has_tablespace_privilege(user, tablespace, privilege) | Checks whether a specified user can access a tablespace in a particular way. |
| has_tablespace_privilege(tablespace, privilege) | Checks whether the current user can access a tablespace in a particular way. |
| has_type_privilege(user, type, privilege) | Checks whether a specified user can access a type in a particular way. |
| has_type_privilege(type, privilege) | Checks whether the current user can access a type in a particular way. |
| pg_has_role(user, role, privilege) | Checks whether a specified user can access a role in a particular way. |
| pg_has_role(role, privilege) | Checks whether the current user can access a role in a particular way. |