Postgres Pro
Downloads
Home   >   mailing lists

Re: REVOKE DROP tables - Mailing list pgsql-admin

From Tom Lane
Subject Re: REVOKE DROP tables
Date
Msg-id 2216.1157206982@sss.pgh.pa.us
Whole thread Raw
In response to REVOKE DROP tables  ("F. Kleinpaul" <fkleinpaul@gmail.com>)
List pgsql-admin
Tree view 
"F. Kleinpaul" <fkleinpaul@gmail.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

pgsql-admin by date:

Previous
From: "F. Kleinpaul"
Date:
Subject: REVOKE DROP tables
Next
From: Bruno Wolff III
Date:
Subject: Re: REVOKE DROP tables