Re: User can not create a new table - Mailing list pgsql-general

From Stephan Szabo
Subject Re: User can not create a new table
Date
Msg-id Pine.BSF.4.21.0105071543520.79137-100000@megazone23.bigpanda.com
Whole thread Raw
In response to User can not create a new table  (Tulio Oliveira <mestredosmagos@marilia.com>)
List pgsql-general
On Mon, 7 May 2001, Tulio Oliveira wrote:

> Hello, All
>
> How I prevent a new user to create new tables in a Data Base ?
>
> The Data Base is owned by "postgres" and I need that only the "postgres"
> user can create new tables ...

I don't think you can allow users to connect to a db but not create
tables at this time.  You should be able to disallow connects to the
db, but I'm guessing that's not what you want.

> Where are the default messages thats appears when the Referentian
> Integrity is violated ? I need change this message to portuguese...

It's compiled in I think from  backend/utils/adt/ri_triggers.c


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: New mirrors on web page
Next
From: Joseph Shraibman
Date:
Subject: Re: 'current' timestamp bug