René's URL Explorer Experiment


Title: Managing Roles for your Postgres database - PlanetScale

Open Graph Title: Managing Roles for your Postgres database - PlanetScale

X Title: Managing Roles for your Postgres database - PlanetScale

Description: When you connect to your database, you have the option to connect with the default role or a user-generated role. This document covers the differences between each option and how to create new roles.

Open Graph Description: When you connect to your database, you have the option to connect with the default role or a user-generated role. This document covers the differences between each option and how to create new roles.

X Description: When you connect to your database, you have the option to connect with the default role or a user-generated role. This document covers the differences between each option and how to create new roles.

Opengraph URL: https://planetscale.com/docs/postgres/connecting/roles

Generator: Mintlify

direct link

Domain: planetscale.com


Hey, it has json ld scripts:
{"@context":"https://schema.org","@type":"WebSite","name":"PlanetScale","creator":{"@type":"Organization","name":"Mintlify","url":"https://mintlify.com"}}
{"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://planetscale.com/#organization","name":"PlanetScale","url":"https://planetscale.com","logo":{"@type":"ImageObject","url":"https://mintcdn.com/planetscale-2/xUilVHToUFALai8a/logo/light.png?fit=max&auto=format&n=xUilVHToUFALai8a&q=85&s=cccd3c9fc813c01b899ab7af15a115b1"}},{"@type":"WebSite","@id":"https://planetscale.com/docs#website","name":"PlanetScale","url":"https://planetscale.com/docs","publisher":{"@id":"https://planetscale.com/#organization"}},{"@type":"WebPage","@id":"https://planetscale.com/docs/postgres/connecting/roles#webpage","url":"https://planetscale.com/docs/postgres/connecting/roles","name":"Managing Roles for your Postgres database","description":"When you connect to your database, you have the option to connect with the default role or a user-generated role. This document covers the differences between each option and how to create new roles.","dateModified":"2026-07-09T18:34:17.457Z","isPartOf":{"@id":"https://planetscale.com/docs#website"},"breadcrumb":{"@id":"https://planetscale.com/docs/postgres/connecting/roles#breadcrumb"}},{"@type":"BreadcrumbList","@id":"https://planetscale.com/docs/postgres/connecting/roles#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Platform","item":"https://planetscale.com/docs/postgres/pricing"},{"@type":"ListItem","position":2,"name":"Connecting","item":"https://planetscale.com/docs/postgres/connecting"},{"@type":"ListItem","position":3,"name":"Managing Roles for your Postgres database","item":"https://planetscale.com/docs/postgres/connecting/roles"}]},{"@type":["Article","TechArticle"],"@id":"https://planetscale.com/docs/postgres/connecting/roles#article","headline":"Managing Roles for your Postgres database","name":"Managing Roles for your Postgres database","description":"When you connect to your database, you have the option to connect with the default role or a user-generated role. This document covers the differences between each option and how to create new roles.","url":"https://planetscale.com/docs/postgres/connecting/roles","mainEntityOfPage":{"@id":"https://planetscale.com/docs/postgres/connecting/roles#webpage"},"dateModified":"2026-07-09T18:34:17.457Z","publisher":{"@id":"https://planetscale.com/#organization"},"isPartOf":{"@id":"https://planetscale.com/docs#website"}}]}

application-namePlanetScale
msapplication-config/docs/_mintlify/favicons/planetscale-2/_bFyi8IG4CeLblEd/_generated/favicon/browserconfig.xml
apple-mobile-web-app-titlePlanetScale
msapplication-TileColor#0e73cc
og:site_namePlanetScale
og:imagehttps://planetscale-2.mintlify.app/_next/image?url=/_mintlify/api/og?division=Connecting&title=Managing+Roles+for+your+Postgres+database&description=When+you+connect+to+your+database%2C+you+have+the+option+to+connect+with+the+default+role+or+a+user-generated+role.+This+document+covers+the+differences+between+e&logoLight=https%3A%2F%2Fmintcdn.com%2Fplanetscale-2%2FxUilVHToUFALai8a%2Flogo%2Flight.png%3Ffit%3Dmax%26auto%3Dformat%26n%3DxUilVHToUFALai8a%26q%3D85%26s%3Dcccd3c9fc813c01b899ab7af15a115b1&logoDark=https%3A%2F%2Fmintcdn.com%2Fplanetscale-2%2FxUilVHToUFALai8a%2Flogo%2Fdark.png%3Ffit%3Dmax%26auto%3Dformat%26n%3DxUilVHToUFALai8a%26q%3D85%26s%3D4153888dc0ef54ddc3464738a2d7ee6e&primaryColor=%230e73cc&lightColor=%2347b7f8&backgroundLight=%23fafafa&backgroundDark=%23111111&w=1200&q=100
og:image:width1200
og:image:height630
og:typewebsite
twitter:cardsummary_large_image
twitter:imagehttps://planetscale-2.mintlify.app/_next/image?url=/_mintlify/api/og?division=Connecting&title=Managing+Roles+for+your+Postgres+database&description=When+you+connect+to+your+database%2C+you+have+the+option+to+connect+with+the+default+role+or+a+user-generated+role.+This+document+covers+the+differences+between+e&logoLight=https%3A%2F%2Fmintcdn.com%2Fplanetscale-2%2FxUilVHToUFALai8a%2Flogo%2Flight.png%3Ffit%3Dmax%26auto%3Dformat%26n%3DxUilVHToUFALai8a%26q%3D85%26s%3Dcccd3c9fc813c01b899ab7af15a115b1&logoDark=https%3A%2F%2Fmintcdn.com%2Fplanetscale-2%2FxUilVHToUFALai8a%2Flogo%2Fdark.png%3Ffit%3Dmax%26auto%3Dformat%26n%3DxUilVHToUFALai8a%26q%3D85%26s%3D4153888dc0ef54ddc3464738a2d7ee6e&primaryColor=%230e73cc&lightColor=%2347b7f8&backgroundLight=%23fafafa&backgroundDark=%23111111&w=1200&q=100
twitter:image:width1200
twitter:image:height630

Links:

/docs/llms.txthttps://planetscale.com/docs/llms.txt
Skip to main contenthttps://planetscale.com/docs/postgres/connecting/roles#content-area
PlanetScale home pagehttps://planetscale.com
Log inhttps://auth.planetscale.com/sign-in
Get startedhttps://auth.planetscale.com/sign-up
Get in touchhttps://planetscale.com/contact
Get in touchhttps://planetscale.com/contact
Platformhttps://planetscale.com/docs
Vitesshttps://planetscale.com/docs/vitess
Postgreshttps://planetscale.com/docs/postgres
API Referencehttps://planetscale.com/docs/api/reference/getting-started-with-planetscale-api
CLI Referencehttps://planetscale.com/docs/cli
Bloghttps://planetscale.com/blog
Contact Ushttps://planetscale.com/contact
Statushttps://www.planetscalestatus.com/
Benchmarkshttps://planetscale.com/benchmarks
Welcomehttps://planetscale.com/docs/postgres
Pricinghttps://planetscale.com/docs/postgres/pricing
Overviewhttps://planetscale.com/docs/postgres/connecting
Quickstarthttps://planetscale.com/docs/postgres/connecting/quickstart
Role managementhttps://planetscale.com/docs/postgres/connecting/roles
PgBouncerhttps://planetscale.com/docs/postgres/connecting/pgbouncer
Proxy error referencehttps://planetscale.com/docs/postgres/connecting/client-error-reference
Neon serverless driverhttps://planetscale.com/docs/postgres/connecting/neon-serverless-driver
IP restrictionshttps://planetscale.com/docs/postgres/connecting/ip-restrictions
Model Context Protocol (MCP)https://planetscale.com/docs/connect/mcp
Self-improving databasehttps://planetscale.com/docs/connect/self-improving-database
Terraform providerhttps://planetscale.com/docs/terraform
Drizzlehttps://planetscale.com/docs/postgres/tutorials/planetscale-postgres-drizzle
Kyselyhttps://planetscale.com/docs/postgres/tutorials/planetscale-postgres-kysely
Prismahttps://planetscale.com/docs/postgres/tutorials/planetscale-postgres-prisma
Laravelhttps://planetscale.com/docs/postgres/tutorials/planetscale-postgres-laravel
Ruby on Railshttps://planetscale.com/docs/postgres/tutorials/planetscale-postgres-rails
Cloudflare Workershttps://planetscale.com/docs/postgres/tutorials/planetscale-postgres-cloudflare-workers
Bunhttps://planetscale.com/docs/postgres/tutorials/planetscale-postgres-bun
Node.jshttps://planetscale.com/docs/postgres/tutorials/planetscale-postgres-node
Default rolehttps://planetscale.com/docs/postgres/connecting/roles#default-role
User-defined roleshttps://planetscale.com/docs/postgres/connecting/roles#user-defined-roles
Available permissionshttps://planetscale.com/docs/postgres/connecting/roles#available-permissions
Creating new user-defined roleshttps://planetscale.com/docs/postgres/connecting/roles#creating-new-user-defined-roles
Creating roles in the dashboardhttps://planetscale.com/docs/postgres/connecting/roles#creating-roles-in-the-dashboard
Creating roles via the CLIhttps://planetscale.com/docs/postgres/connecting/roles#creating-roles-via-the-cli
Available commandshttps://planetscale.com/docs/postgres/connecting/roles#available-commands
Creating roles via CREATE ROLEhttps://planetscale.com/docs/postgres/connecting/roles#creating-roles-via-create-role
Viewing, deleting, and renaming roleshttps://planetscale.com/docs/postgres/connecting/roles#viewing-deleting-and-renaming-roles
Deleting a rolehttps://planetscale.com/docs/postgres/connecting/roles#deleting-a-role
Reassigning objects owned by a rolehttps://planetscale.com/docs/postgres/connecting/roles#reassigning-objects-owned-by-a-role
Resetting role credentialshttps://planetscale.com/docs/postgres/connecting/roles#resetting-role-credentials
User-defined role examples and use caseshttps://planetscale.com/docs/postgres/connecting/roles#user-defined-role-examples-and-use-cases
When to use user-defined roles vs. the default rolehttps://planetscale.com/docs/postgres/connecting/roles#when-to-use-user-defined-roles-vs-the-default-role
Example role configurationshttps://planetscale.com/docs/postgres/connecting/roles#example-role-configurations
Need help?https://planetscale.com/docs/postgres/connecting/roles#need-help
user-defined roleshttps://planetscale.com/docs/postgres/connecting/roles#user-defined-roles
https://planetscale.com/docs/postgres/connecting/roles#default-role
https://planetscale.com/docs/postgres/connecting/roles#user-defined-roles
User-defined role examples and use caseshttps://planetscale.com/docs/postgres/connecting/roles#user-defined-role-examples-and-use-cases
https://planetscale.com/docs/postgres/connecting/roles#available-permissions
https://planetscale.com/docs/postgres/connecting/roles#creating-new-user-defined-roles
CREATE ROLEhttps://www.postgresql.org/docs/current/sql-createrole.html
Roles APIhttps://planetscale.com/docs/api/reference/list_roles
pscale role commandshttps://planetscale.com/docs/cli/role
https://planetscale.com/docs/postgres/connecting/roles#creating-roles-in-the-dashboard
https://planetscale.com/docs/postgres/connecting/roles#creating-roles-via-the-cli
PlanetScale CLIhttps://planetscale.com/docs/cli
https://planetscale.com/docs/postgres/connecting/roles#available-commands
https://planetscale.com/docs/postgres/connecting/roles#creating-roles-via-create-role
pscale rolehttps://planetscale.com/docs/cli/role
Roles APIhttps://planetscale.com/docs/api/reference/create_role
CREATE ROLEhttps://www.postgresql.org/docs/current/sql-createrole.html
https://planetscale.com/docs/postgres/connecting/roles#viewing-deleting-and-renaming-roles
https://planetscale.com/docs/postgres/connecting/roles#deleting-a-role
delete a role using the pscale role CLIhttps://planetscale.com/docs/cli/role#the-delete-sub-command
https://planetscale.com/docs/postgres/connecting/roles#reassigning-objects-owned-by-a-role
https://planetscale.com/docs/postgres/connecting/roles#resetting-role-credentials
https://planetscale.com/docs/postgres/connecting/roles#user-defined-role-examples-and-use-cases
https://planetscale.com/docs/postgres/connecting/roles#when-to-use-user-defined-roles-vs-the-default-role
https://planetscale.com/docs/postgres/connecting/roles#example-role-configurations
pg_stricthttps://planetscale.com/docs/postgres/extensions/pg_strict
https://planetscale.com/docs/postgres/connecting/roles#need-help
the PlanetScale Support teamhttps://planetscale.com/contact?initial=support
Discord communityhttps://pscale.link/community
Connections quickstartPrevioushttps://planetscale.com/docs/postgres/connecting/quickstart
PgBouncerNexthttps://planetscale.com/docs/postgres/connecting/pgbouncer
xhttps://twitter.com/planetscale
githubhttps://github.com/planetscale
linkedinhttps://www.linkedin.com/company/planetscale
youtubehttps://www.youtube.com/c/PlanetScale
discordhttps://pscale.link/community
facebookhttps://www.facebook.com/planetscaledata
Powered byThis documentation is built and hosted on Mintlify, a developer documentation platformhttps://www.mintlify.com?utm_campaign=poweredBy&utm_medium=referral&utm_source=planetscale-2

Viewport: width=device-width, initial-scale=1, viewport-fit=cover


URLs of crawlers that visited me.