{"podcast":{"title":"Postgres FM","slug":"postgres-fm-5565051","podcast_index_feed_id":5565051,"rss_url":"https://feeds.transistor.fm/postgres-fm","website_url":null,"image_url":"https://img.transistorcdn.com/F-bi_aUNst-Ey8rEcRiURSNfKPb3cxsaDOvekkdqtR8/rs:fill:0:0:1/w:1400/h:1400/q:60/mb:500000/aHR0cHM6Ly9pbWct/dXBsb2FkLXByb2R1/Y3Rpb24udHJhbnNp/c3Rvci5mbS9zaG93/LzMyMTQ3LzE3MTA3/OTEzODMtYXJ0d29y/ay5qcGc.jpg","author":"Nikolay Samokhvalov and Michael Christofides","episode_count":184,"summary":"A weekly podcast about all things PostgreSQL","last_synced_at":"2026-07-25T00:17:17.794402+00:00","page_url":"https://stenobird.com/podcast/postgres-fm-5565051"},"episode":{"title":"User management","slug":"user-management","published_at":"2025-10-03T13:00:00+00:00","page_url":"https://stenobird.com/podcast/postgres-fm-5565051/user-management","show_page_url":"https://stenobird.com/podcast/postgres-fm-5565051","url":"https://share.transistor.fm/s/a6c3ed12","audio_url":"https://media.transistor.fm/a6c3ed12/f44394d3.mp3","summary":"Nik and Michael discuss user management in Postgres — how roles work, making administration easier, setting passwords, and avoiding them being logged. Here are some links to things they mentioned: Roles https://www.postgresql.org/docs/current/user-manag.html Privileges https://www.postgresql.org/docs/current/ddl-priv.html ALTER DEFAULT PRIVILEGES https://www.postgresql.org/docs/current/sql-alterdefaultprivileges.html GRANT https://www.postgresql.org/docs/current/sql-grant.html REASSIGN OWNED https://www.postgresql.org/docs/current/sql-reassign-owned.html ALTER ROLE (including SET) https://www.postgresql.org/docs/current/sql-alterrole.html CREATE ROLE https://www.postgresql.org/docs/current/sql-createrole.html Have I Been Pwned https://haveibeenpwned.com Pwned Passwords API https://haveibeenpwned.com/API/v3#PwnedPasswords Crunchy Data PostgreSQL Security Technical Implementation Guide (STIG) https://www.crunchydata.com/blog/announcing-the-crunchy-data-postgresql-stig Our episode on auditing https://postgres.fm/episodes/auditing ~~~ What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc ! ~~~ Postgres FM is produced by: Michael Christofides, founder of pgMustard Nikolay Samokhvalov, founder of Postgres.ai With credit to: Jessie Draws for the elephant artwork","meta_description":"Nik and Michael discuss user management in Postgres — how roles work, making administration easier, setting passwords, and avoiding them being logged. Her…","key_points":[],"chapters":[],"topics":[],"duration_seconds":2340,"processing_state":"not_requested","actions":[{"name":"request_transcript","method":"POST","url":"https://stenobird.com/v1/public/podcasts/postgres-fm-5565051/episodes/user-management/transcription-requests","description":"Idempotently request low-priority transcript generation for this episode."},{"name":"read_markdown","method":"GET","url":"https://stenobird.com/podcast/postgres-fm-5565051/user-management.md","description":"Read the agent-friendly Markdown representation of this episode resource."}]}}