问题描述
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中进行表数据编辑的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!