Postgres Pro
Downloads
Home   >   mailing lists

Permissions on databases (not on tables) - Mailing list pgsql-general

From Victor Sudakov
Subject Permissions on databases (not on tables)
Date
Msg-id 20000919113834.A40826@sibptus.tomsk.ru
Whole thread Raw
List pgsql-general
Tree view 
Colleagues.

Could you please tell me how I can prevent a user from creating tables
in a database belonging to another user?

I login as user1, create a database, then logout, connect to the
database as user2 and create tables in it. Is this behavior by design?
And how can I prevent this from happening, i.e. restrict user rights per
database?

Thanks for any input.

--
Victor Sudakov,  VAS4-RIPE, VAS47-RIPN
2:5005/149@fidonet http://vas.tomsk.ru/

pgsql-general by date:

Previous
From: "He Weiping (Laser Henry)"
Date:
Subject: Re: Psql Question
Next
From: "Alexey V. Borzov"
Date:
Subject: Re[2]: WTF is going on with PG_VERSION?