On 2024-Nov-13, Vijaykumar Jain wrote: > I tried to grant select permissions to 5000 different roles on one table, > It failed with row size too big already at 2443. But you can grant select to one "reader" role, and grant that one role to however many other roles you want. This way you can have an arbitrary number of roles with indirect access to the table. In real-world usage, this is more convenient that granting access to individual roles on individual tables; likely, you'll grant access to sets of tables/views/functions/etc rather than exactly one, and you can manage that more easily if you have one intermediate role to modify than if you have to mess with 5000 individual roles. -- Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/
