Developer中进行表数据编辑

Developer中进行表数据编辑

本文介绍了防止在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工作表,或单击绿色的勾号按钮或按.

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 .

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

Pressing Will Rollback Changes that have not been committed.

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

08-01 15:55