DT
Drizzle Team•4mo ago
rcamf

Grant Privileges to Role

I created roles in my project using the pgRole() in order to enable RLS on my database. After running the migration my user has no privileges on my tables and cannot access them. How can I grant all privileges to my role?
1 Reply
RWOverdijk
RWOverdijk•3w ago
Did you ever figure this out? Because the only thing I can think of is manually adding this to migrations One last attempt ping, I hope you see this and have an answer 😅 I have a solution now, but I don't like it.

Did you find this page helpful?