Predefined roles v17
A set of predefined roles provides access to certain, commonly needed, privileged capabilities and information. Administrators including roles that have the CREATE ROLE privilege can GRANT these roles to users and/or other roles in their environment. The users/roles with these roles will have access to the specified capabilities and information.
For the complete list of the PostgreSQL's predefined roles, see Predefined roles in the PostgreSQL documentation.
The following table provides the predefined roles specific to EDB Postgres Advanced Server:
| Role | Allowed access |
|---|---|
| aq_administrator_role | Allows creation and administration of queuing infrastructure. |
| capture_admin | Allows the execute permission on the DBMS_PRIVILEGE_CAPTURE package. |
| edb_createdirectory_admin | Allows the user to create a directory. |
| edb_dropdirectory_admin | Allows the user to drop any directory. |