| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Tulio Oliveira <mestredosmagos(at)marilia(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org, psql-hacker(at)postgresql(dot)org |
| Subject: | Re: User can not create a new table |
| Date: | 2001-05-07 22:46:47 |
| Message-ID: | Pine.BSF.4.21.0105071543520.79137-100000@megazone23.bigpanda.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2001-05-07 22:56:38 | New mirrors on web page |
| Previous Message | Ian Harding | 2001-05-07 22:30:39 | ALTER TABLE ADD CONSTRAINT |