pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedREVOKE DROP tables
3+ messages / 3 participants
[nested] [flat]
* REVOKE DROP tables
@ 2006-09-02 11:33 F. Kleinpaul <fkleinpaul@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: F. Kleinpaul @ 2006-09-02 11:33 UTC (permalink / raw)
To: pgsql-admin
How can I REVOKE users right to DROP tables?
Thanks
FKleinpaul
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: REVOKE DROP tables
@ 2006-09-02 14:23 Tom Lane <tgl@sss.pgh.pa.us>
parent: F. Kleinpaul <fkleinpaul@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Tom Lane @ 2006-09-02 14:23 UTC (permalink / raw)
To: F. Kleinpaul <fkleinpaul@gmail.com>; +Cc: pgsql-admin
"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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: REVOKE DROP tables
@ 2006-09-03 18:55 Bruno Wolff III <bruno@wolff.to>
parent: F. Kleinpaul <fkleinpaul@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Bruno Wolff III @ 2006-09-03 18:55 UTC (permalink / raw)
To: F. Kleinpaul <fkleinpaul@gmail.com>; +Cc: pgsql-admin
On Sat, Sep 02, 2006 at 08:33:52 -0300,
"F. Kleinpaul" <fkleinpaul@gmail.com> wrote:
> How can I REVOKE users right to DROP tables?
The owner of a table can always drop it. So you would need to change
the owner of the table using ALTER TABLE table_name OWNER TO new_owner.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2006-09-03 18:55 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-09-02 11:33 REVOKE DROP tables F. Kleinpaul <fkleinpaul@gmail.com>
2006-09-02 14:23 ` Tom Lane <tgl@sss.pgh.pa.us>
2006-09-03 18:55 ` Bruno Wolff III <bruno@wolff.to>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox