Re: [GENERAL] Per-user schemas with inherited skeleton.

2009-01-05 Thread alvarezp
On Mon, 2009-01-05 at 13:05 +0900, Craig Ringer wrote: > alvar...@alvarezp.ods.org wrote: > > > On user account creation, the schema gets created and the interface > > tries to do a "CREATE TABLE my_relation () INHERITS > > (_skel.my_relation);" as the new role, but PostgreSQL returns the error > >

[GENERAL] Per-user schemas with inherited skeleton.

2009-01-03 Thread alvarezp
Hello. I am testing different security models to use on a new database, where I want different users to be restricted to their own data. Users would be able to connect to the database through an interface, but in particular cases of advanced users, they will be able to directly connect to the da