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

+ Recent posts