pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
REVOKE DROP tables
3+ messages / 3 participants
[nested] [flat]

* REVOKE DROP tables
@ 2006-09-02 11:33 F. Kleinpaul <fkleinpaul@gmail.com>
  2006-09-02 14:23 ` Re: REVOKE DROP tables Tom Lane <tgl@sss.pgh.pa.us>
  2006-09-03 18:55 ` Re: REVOKE DROP tables Bruno Wolff III <bruno@wolff.to>
  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 11:33 REVOKE DROP tables F. Kleinpaul <fkleinpaul@gmail.com>
@ 2006-09-02 14:23 ` Tom Lane <tgl@sss.pgh.pa.us>
  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-02 11:33 REVOKE DROP tables F. Kleinpaul <fkleinpaul@gmail.com>
@ 2006-09-03 18:55 ` Bruno Wolff III <bruno@wolff.to>
  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