db1=> create table schema1.dbtable1 (hid int); ERROR: permission denied for schema schema1 LINE 1: create table schema1.dbtable1 (hid int); db1=> create table schema2.dbtable2 (hid int); ERROR: permission denied for schema schema2 LINE 1: create table schema2.dbtable2 (hid int)...
public | t1 | table | dlq16050 public | t2 | table | dlq16050 (2 rows) user2@HQ-SIT-kafka013:5432/test=> SELECT * from t1 ; id --- (0 rows) Time: 1.569 ms user2@HQ-SIT-kafka013:5432/test=> SELECT * from t2 ; ERROR: permission denied for table t2 Time: 1.338 ms # ...