pg14-database1 appuser => select * from schema1.table1 limit 5; ERROR: permission denied for schema schema1 LINE 1: select * from schema1.table1 limit 5 ; 神奇之旅开始,我们可以使用postgresql 14中预先定义的角色: 1 2 pg14-database1 postgres =# grant pg_read_all_data to appuser ;...
Why is pg_read_all_data a “killer feature”? In a perfect world, no one would require such convenience functionality - given, of course, that everyone knew more or less exactly how their data model was going to look like, could predict how it was going to be used, and more importa...