DROP EXTENSION DROP EXTENSION DROP FOREIGN DATA WRAPPER DROP ROLE CREATE ROLE You are now connected to database "test" as user "ro". CREATE EXTENSION CREATE EXTENSION CREATE SERVER CREATE FOREIGN DATA WRAPPER You are now connected to database "test" as user "postgres". GRANT GRANT GRANT GRANT rolname | relacl ---------+----------------- ro | {ro=arwdDxt/ro} (1 row) rolname | typacl ---------+----------------- ro | {=U/ro,ro=U/ro} (1 row) rolname | srvacl ---------+----------- ro | {ro=U/ro} (1 row) rolname | fdwacl ---------+----------- ro | {ro=U/ro} (1 row) REASSIGN OWNED rolname | relacl ---------+--------------------------- test_ui | {test_ui=arwdDxt/test_ui} (1 row) rolname | typacl ---------+-------------------------------- test_ui | {=U/test_ui,test_ui=U/test_ui} (1 row) rolname | srvacl ---------+--------------------- test_ui | {test_ui=U/test_ui} (1 row) rolname | fdwacl ---------+--------------------- test_ui | {test_ui=U/test_ui} (1 row) ALTER TABLE ALTER TYPE ALTER SERVER ALTER FOREIGN DATA WRAPPER rolname | relacl ---------+----------------- ro | {ro=arwdDxt/ro} (1 row) rolname | typacl ---------+----------------- ro | {=U/ro,ro=U/ro} (1 row) rolname | srvacl ---------+----------- ro | {ro=U/ro} (1 row) rolname | fdwacl ---------+----------- ro | {ro=U/ro} (1 row)