Re: Define permissions at database level

From: Richard Huxton <dev(at)archonet(dot)com>
To: dipti shah <shahdipti1980(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Define permissions at database level
Date: 2010-02-18 10:39:45
Message-ID: 4B7D18F1.6040108@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message dipti shah 2010-02-18 10:54:40 Re: Define permissions at database level
Previous Message dipti shah 2010-02-18 10:34:44 Re: Define permissions at database level

Browse pgsql-novice by date

  From Date Subject
Next Message dipti shah 2010-02-18 10:54:40 Re: Define permissions at database level
Previous Message dipti shah 2010-02-18 10:34:44 Re: Define permissions at database level