I've been through the docs and mail archieve and haven't found a solution
to my problem.

I'd like to be able to configure users so that they cannot create 
tables in certain databases.

I'll have a setup like this

Database    Use
dev         tables under development
prod        tables in normal use
private     tables in normal use by select few people

I don't want anyone except developers in the dev database.
I don't want anyone except developers to to able to create tables in the
proc and private databases.

But 

When I log in as a normal user and I can create tables anywhere I want.

I'm thinking the blocking from entering a database can be done from
pg_hba.conf but the table creation blocking I can't find any information
on.

Is it possible?

->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<
James Thompson    138 Cardwell Hall  Manhattan, Ks   66506    785-532-0561 
Kansas State University                          Department of Mathematics
->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<




************

Reply via email to