psql grant, logs configurations

psql-grant.md

# display privileges
SELECT grantee, privilege_type FROM information_schema.role_table_grants WHERE table_name='some_table_name';

  grantee  | privilege_type
-----------+----------------
 root      | INSERT
 root      | SELECT
 root      | UPDATE
 root      | DELETE
 root      | TRUNCATE
 root      | REFERENCES
 root      | TRIGGER
 
 
# add privileges for (select, insert, update, delete) of all tables to a user
GRANT select, insert, update, delete on all tables in schema public to some_user_name;

GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public TO some_user_name;

psql-set-echo-query-logs.md

# Show log_statement current config
SELECT current_setting('log_statement');
 current_setting
-----------------
 none
(1 row)

# Turn on echo query log
ALTER DATABASE databse_name set log_statement = 'all';

# Turn off echo query log
ALTER DATABASE database_name set log_statement = 'none';

# Reload conf
select pg_reload_conf();

References

• https://www.postgresql.org/docs/9.3/functions-admin.html
• https://www.postgresql.org/docs/9.5/runtime-config-logging.html#GUC-LOG-STATEMENT