new

text/plain

Download

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)