Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to prevent table from being dropped?

Tags:

postgresql

In PostgreSQL, how can I prevent anyone (including superusers) from dropping some specific table?

EDIT: Whoa, did we have some misunderstanding here. Let's say there is a big, shared QA database. Sometimes people run destructive things like hibernate-generated schema on it by mistake, and I'm looking for ways to prevent such mistakes.

like image 560
Konrad Garus Avatar asked Jun 27 '13 10:06

Konrad Garus


1 Answers

anyone (including superusers) from dropping some specific table?

Trust your peers.

like image 161
ta.speot.is Avatar answered Oct 20 '22 06:10

ta.speot.is