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' 카테고리의 다른 글

postgresql default role  (0) 2019.08.23
테이블 사이즈 확인  (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