Postgres Pro
Downloads
Home   >   mailing lists

Re: Define permissions at database level - Mailing list pgsql-general

From Richard Huxton
Subject Re: Define permissions at database level
Date
Msg-id 4B7D18F1.6040108@archonet.com
Whole thread Raw
In response to Re: Define permissions at database level  (dipti shah <shahdipti1980@gmail.com>)
Responses Re: Define permissions at database level  (dipti shah <shahdipti1980@gmail.com>)
List pgsql-general
Tree view 
On 18/02/10 10:34, dipti shah wrote:
> Actually, I don't want table owners to drop the table using DROP command
> directly. They have to use stored procedure to drop the table.

Then don't let them own the table. Or rather, the role they log in to
the database as shouldn't.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: dipti shah
Date:
Subject: Re: Define permissions at database level
Next
From: dipti shah
Date:
Subject: Re: Define permissions at database level