Hubert 'depesz' Lubaczewski:系统角色——是什么,为什么,如何?
原文英文,约1800词,阅读约需7分钟。发表于: 。Not everyone knows, but at since PostgreSQL 9.6, we have some built-in roles. Of course, there is always superuser (usually called postgres), but I'm not talking about it. I'm talking about...
PostgreSQL 9.6开始,我们有一些以pg_开头的内置角色,它们是组,不能用于登录数据库,但可以授予用户更多的权限,包括CHECKPOINT命令,pg_database_owner角色,pg_execute_server_program,pg_read_all_settings,pg_read_all_stats,pg_stat_scan_tables,pg_signal_backend和pg_use_reserved_connections等。