Assign a UAPP PostgreSQL User to a Database
Grant the panel-managed PostgreSQL database and public-schema access set to an account-owned user on the same server.
Open Databases → PostgreSQL → Assign User to Database.
| Field | Requirement |
|---|---|
| Database | Existing database in the account inventory. |
| User | Existing account user on the same server. |
The page redirects to creation if a database or user is missing. It rejects cross-server pairs. There is no custom privilege checkbox list in this form.
What assignment grants
The helper grants ALL PRIVILEGES on the selected database, the public schema and all existing tables, sequences and functions in that schema. It records the assignment as ALL PRIVILEGES.
This does not transfer ownership, grant a superuser role or cover every other schema. The helper does not configure default privileges for future objects; newly created objects may need their own grants. Independent role membership and ownership can also affect effective access.
Assign and verify
Select the pair, review its server and submit. Check the response and database assignments, then test the application's required operations. The current assignment view has no explicit demo guard.
Assignment is a broad grant
Use a role intended for this database and review whether the panel's fixed access set fits the application. This page does not offer a narrower custom role policy.
Use the explicit removal action in PostgreSQL Databases to revoke the panel-managed set. Do not treat repeat assignment as a method for reducing existing privileges. Password, application configuration and server/network authentication still require separate verification.