甚至通过superadmin/dba防止删除/更新表吗? [英] Prevent delete/update for tables by even superadmin/dba?

问题描述

我需要确保某些关键任务表永远不会被删除或编辑.唯一可能的操作是从中读取数据，并且dba可以添加更多行.而已.

There are some mission critical tables which i need to ensure never get deleted or edited. only possible action is to read from it and the dba can add more rows. That's it.

现在，为了增强安全性，我甚至想防止dba能够删除/更改记录，因此基本上没有人可以删除或更改记录，也没有超级管理员.这些表对于我需要无限期保存的某些类型的用户数据的活动跟踪至关重要，而某些表则是关键的查找表.因此，系统锁定值和用户跟踪值是混合在一起的.

Now for added security i want to prevent even the dba from being able to delete/alter the records, so basically no one can ever delete or alter a record, no super admin also. These tables are critical for activity tracking of certain type of users who's data i need to preserve indefinitely and some are critical lookup tables. So a mixture of system locked values and user tracked values.

想法是，如果有人想要销毁他们需要杀死该数据库的数据.有办法吗?

Idea is if someone wants to destroy the data they need to kill that database. Is there a way to do this?

推荐答案

否，不可能，超级用户始终由数据库控制.您可以撤消更新和删除权限，但是超级用户总是可以再次将这些权限授予自己.

No, not possible, the superuser is always in control of the database. You could REVOKE update and delete permissions, but a superuser can always GRANT these permissions to himself again.

这篇关于甚至通过superadmin/dba防止删除/更新表吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！