Re: REVOKE DROP tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "F(dot) Kleinpaul" <fkleinpaul(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: REVOKE DROP tables
Date: 2006-09-02 14:23:02
Message-ID: 2216.1157206982@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"F. Kleinpaul" <fkleinpaul(at)gmail(dot)com> writes:
> How can I REVOKE users right to DROP tables?

Only the owner can drop a table. Perhaps you are looking for
ALTER TABLE ... OWNER ?

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Bruno Wolff III 2006-09-03 18:55:34 Re: REVOKE DROP tables
Previous Message F. Kleinpaul 2006-09-02 11:33:52 REVOKE DROP tables