Cheat Sheet logoCheat Sheet Today
PostgreSQL Cheat Sheet/Create login role

Create a role that can log in.

Back to sheetBrowse commands
Sign in to save
Section: Database and Role Lifecycle

Create login role

sql
sql
CREATE ROLE appuser WITH LOGIN PASSWORD 'secret';
Explanation

Roles replace the older distinction between users and groups.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing Database and Role Lifecycle
Create role with privileges
Create a role with explicit capability flags.
OpenIn sheetsqlsame section
Change role password
Update a role password.
OpenIn sheetsqlsame section
Drop role
Remove a role from the cluster.
OpenIn sheetsqlsame section
Create database
Create a new database in the cluster.
OpenIn sheetsqlsame section
Create database with owner
Create a database with explicit owner and template.
OpenIn sheetsqlsame section
Grant role membership
Add a role as a member of another role.
OpenIn sheetsqlsame section