表一字段update權限

發布時間：2020-08-13 04:32:36 來源：ITPUB博客閱讀：182 作者：wanghao2979 欄目：關系型數據庫

1.創建環境
SQL> create user ltest identified by ltest;

User created.

SQL> grant connect,resource to ltest;

Grant succeeded.

2.嘗試更新

SQL> update system.test set object_id=1;
update system.test set object_id=1
*
ERROR at line 1:
ORA-00942: table or view does not exist

3.賦權

SQL> grant select,update(object_id) on system.test to ltest;

Grant succeeded.

4.嘗試更新

SQL> grant select,update(object_id) on system.test to ltest;

Grant succeeded.

SQL> connect ltest/ltest
Connected.
SQL> update system.test set object_id=1;

74883 rows updated.

SQL> rollback;

Rollback complete.

向AI問一下細節

91超碰碰碰碰久久久久久综合_超碰av人澡人澡人澡人澡人掠_国产黄大片在线观看画质优化_txt小说免费全本

表一字段update權限

猜你喜歡

91超碰碰碰碰久久久久久综合_超碰av人澡人澡人澡人澡人掠_国产黄大片在线观看画质优化_txt小说免费全本

表一字段update權限

猜你喜歡

最新資訊

相關推薦

相關標簽