postgresql의 default role.
admin 권한이 아닌 role에 grant 하면 됨
pg_read_all_settings | Read all configuration variables, even those normally visible only to superusers. |
pg_read_all_stats | Read all pg_stat_* views and use various statistics related extensions, even those normally visible only to superusers. |
pg_stat_scan_tables | Execute monitoring functions that may take ACCESS SHARE locks on tables, potentially for a long time. |
pg_signal_backend | Send signals to other backends (eg: cancel query, terminate). |
pg_read_server_files | Allow reading files from any location the database can access on the server with COPY and other file-access functions. |
pg_write_server_files | Allow writing to files in any location the database can access on the server with COPY and other file-access functions. |
pg_execute_server_program | Allow executing programs on the database server as the user the database runs as with COPY and other functions which allow executing a server-side program. |
pg_monitor | Read/execute various monitoring views and functions. This role is a member of pg_read_all_settings, pg_read_all_stats and pg_stat_scan_tables. |
'DataBase > Postgresql' 카테고리의 다른 글
테이블 사이즈 확인 (0) | 2019.08.13 |
---|---|
role에 속한 계정 조회 (0) | 2019.08.13 |
테이블단위 autovacuum 끄기 (0) | 2019.08.13 |
Postgresql 테이블 정보, 컬럼 정보 조회 (0) | 2017.11.23 |
postgresql 한글정렬 (0) | 2017.10.12 |