From: | Magnus Reftel <magnus(dot)reftel(at)gmail(dot)com> |
---|---|
To: | Bill Moran <wmoran(at)potentialtech(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Thousands of users using one schema -> ERROR: row is too big |
Date: | 2011-03-01 21:04:41 |
Message-ID: | 495F4357-1ED4-4D01-BA85-DD6A1321A6A1@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mar 1, 2011, at 21:57 , Bill Moran wrote:
> In response to Magnus Reftel <magnus(dot)reftel(at)gmail(dot)com>:
>>
>> I'm working on a database that will have a very large number of users, and I'm running in to a problem: when I grant more than about 2500 users access to a schema, I get
>>
>> my_db=# grant usage on schema my_schema to some_user;
>> ERROR: row is too big: size 8168, maximum size 8164
>>
>> This of course makes access control tricky on high user-count setups.
> I would think that a better solution would be to follow best practices and
> create roles and put users in those roles, so you don't have to have so
> many grants on objects.
Right, that grant was actually useless, since the users already have usage rights to the schema via a role.
Problem solved. Sorry for the noise!
Thanks!
Magnus Reftel
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2011-03-01 21:13:36 | #PgEast Training Schedule Up |
Previous Message | Bill Moran | 2011-03-01 20:57:15 | Re: Thousands of users using one schema -> ERROR: row is too big |