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 other roles in their environment. The users or roles with these roles will have access to the specified capabilities and information.
For the complete list of the PostgreSQL predefined roles, see Predefined roles in the PostgreSQL documentation.
The table provides the predefined roles specific to EDB Postgres Advanced Server.
| Role | Allowed access |
|---|---|
| aq_administrator_role | Creating and administering queuing infrastructure |
| capture_admin | Execute permission on the DBMS_PRIVILEGE_CAPTURE package |
| edb_createdirectory_admin | Ability to create a directory |
| edb_dropdirectory_admin | Ability to drop any directory |