Create a user on PostgreSQL: Revision history

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

4 February 2025

  • curprev 12:4512:45, 4 February 2025‎ 413vhcu1lq0463ob talk contribs‎ 1,599 bytes +1,599‎ Created page with "To create an user on a PostgreSQL database you can use: CREATE USER new_user WITH PASSWORD 'password'; To guarantee full access on a database you can: GRANT ALL PRIVILEGES ON DATABASE database_name TO new_user; Also to allow the user to connect on the database you need to: GRANT CONNECT ON DATABASE database_name TO new_user; If you want the user to have full access to all tables, sequences, and other objects in the database, you can use: \c database_name  -- To con..." Tag: Visual edit
Retrieved from "https://pedromussato.com/index.php/Create_a_user_on_PostgreSQL"