See who has access to the PXF protocol

Products

• VMware Tanzu Greenplum

Issue/Introduction

How do I see who has access to the PXF protocol?

gpadmin=# create user scott with login;
NOTICE:  resource queue required -- using default resource queue "pg_default"
CREATE ROLE
gpadmin=# create extension pxf;
CREATE EXTENSION
gpadmin=# grant all on protocol pxf to scott;
GRANT

Environment

Product Version: 5.17

Resolution

To see who has been granted access, you can run the following:

gpadmin=# select ptcacl from pg_extprotocol where ptcname = 'pxf';
                ptcacl
---------------------------------------
 {gpadmin=ar/gpadmin,scott=ar/gpadmin}
(1 row)