On Mar 1, 2011, at 21:57 , Bill Moran wrote:
> In response to Magnus Reftel <magnus.ref...@gmail.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
-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to