防止在Oracle SQL Developer中进行表数据编辑 [英] Prevent table data editing in Oracle SQL Developer

问题描述

Oracle SQL Developer中是否可以以任何方式查看表数据只读或阻止编辑?当我查看表中的数据时，可以进行编辑，并且希望避免意外更改.我希望有一种方法可以某种方式进行切换，但是我还没有找到它.我正在使用2.1.1.64版.

Is there any way in Oracle SQL Developer to view table data read-only or prevent editing? When I view the data in a table it lets me edit, and I want to avoid accidentally making a change. I would expect there to be a way to toggle this somehow, but I haven't found it. I'm using version 2.1.1.64.

推荐答案

是的.要求您的DBA创建一个仅对该表具有读权限的用户，然后以该用户身份登录.

Yes there is. Ask your DBA to create a user that only has read access to the TABLES in question and then log in with that user.

要记住的另一件事是，如果您确实在数据网格中编辑了一些数据以便将更改写入数据库，则必须通过在命令行中发出COMMIT命令将更改分别提交给数据库. SQL工作表，或单击绿色的勾号按钮或按 F11 .

The other thing to remember is that if you do edit some data in a data grid in order for the change to written to the database you have to separately commit the change to the database by either issuing a COMMIT command in an SQL Worksheet or by clicking on the Green Tick button or pressing F11.

按 F12 将回滚尚未提交的更改.

Pressing F12 Will Rollback Changes that have not been committed.

这篇关于防止在Oracle SQL Developer中进行表数据编辑的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！