N
Neon•13mo ago
blank-aquamarine

Grant "pg_read_all_data"

Hello, is it possible to grant pg_read_all_data/pg_write_all_data to a user created via sql? 
  grant pg_read_all_data to ${ownerCredential.user};
  grant pg_write_all_data to ${ownerCredential.user};
  grant pg_read_all_data to ${ownerCredential.user};
  grant pg_write_all_data to ${ownerCredential.user};
At the moment I'm getting: 
Only roles with the ADMIN option on role "pg_read_all_data" may grant this role.
Only roles with the ADMIN option on role "pg_read_all_data" may grant this role.
3 Replies
other-emerald
other-emerald•13mo ago
I think the neon_superuser has these roles.
blank-aquamarine
blank-aquamarineOP•13mo ago
yes I think so, but I can't assign this to a new role
foreign-sapphire
foreign-sapphire•13mo ago
Hey! I think you'll find this docs guide helpful https://neon.tech/docs/manage/database-access#create-a-developer-role
Neon
Manage database access - Neon Docs
Each Neon project is created with a Postgres role that is named for your database. For example, if your database is named neondb, the project is created with a role named neondb_owner. This Postgres r...

Did you find this page helpful?