Neon•5d ago

create new role for app

Hi how do i create a new role that has full access to run migrations andaccess all the tables necessary for a nextjs app? Can i just create the role through the Neon "Roles" page? When i create it, does it have all the necessary permission for my need?

instant-harlequin•12/12/25, 2:19 PM

Hey!
Indeed you can create roles from the Tables tab, but they start with no permissions, so they won't be able to access existing tables or run migrations by default. However, the UI makes it quite easy to add privileges to the role based on what you need.

developed-pinkOP•12/13/25, 2:52 AM

Hi @Sam I dont see where in the UI i can edit the privdelges for the role. Where is it?

instant-harlequin•12/13/25, 3:41 AM

Using the add privileges button, however you might find it easier to do this using SQL. I'd recommend having a read at this piece of documentation here : https://neon.com/postgresql/postgresql-administration/postgresql-grant

Neon

PostgreSQL GRANT Statement

In this tutorial, you will learn how to use the PostgreSQL GRANT statement to grant privileges on database objects to a role.

instant-harlequin•12/14/25, 12:07 PM

This is the location on the Tables page that Sam was referring to, I believe.

developed-pinkOP•12/15/25, 12:25 AM

where do you see that in the Tables Page? I cannot see where all the roles are

Ddeveloped-pink where do you see that in the Tables Page? I cannot see where all the roles are

instant-harlequin•12/15/25, 12:29 AM

You click the little ++ under the schema selection dropdown