表一字段update權限
1.創(chuàng)建環(huán)境
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.
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.
文章名稱：表一字段update權限
標題URL：http://chinadenli.net/article30/ihgipo.html
成都網(wǎng)站建設公司_創(chuàng)新互聯(lián)，為您提供外貿建站、用戶體驗、靜態(tài)網(wǎng)站、手機網(wǎng)站建設、網(wǎng)頁設計公司、App開發(fā)
聲明：本網(wǎng)站發(fā)布的內容（圖片、視頻和文字）以用戶投稿、用戶轉載內容為主，如果涉及侵權請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內容未經(jīng)允許不得轉載，或轉載時需注明來源： 創(chuàng)新互聯(lián)
- 全網(wǎng)營銷有步驟嗎？ 2015-06-23
- 企業(yè)手機網(wǎng)站建設在全網(wǎng)營銷趨勢下的意義 2014-02-06
- 全網(wǎng)營銷推廣，讓成交變得簡單 2016-11-08
- 全網(wǎng)營銷具體指的是什么呢? 2014-07-07
- 網(wǎng)站想要實現(xiàn)全網(wǎng)營銷需要做到哪些內容？ 2015-12-21
- 全網(wǎng)營銷推廣：網(wǎng)站URL優(yōu)化策略大全 2016-11-07
- 有關索象全網(wǎng)營銷推廣效果的猜想 2020-10-10
- 全網(wǎng)營銷必知的10大營銷方法技巧！ 2015-06-22
- 全網(wǎng)營銷推廣方案制作流程 2016-11-10
- 網(wǎng)絡營銷中全網(wǎng)營銷對企業(yè)有什么幫助？ 2014-08-02
- 北京全網(wǎng)營銷外包公司敘述新聞營銷的巨大價值 2015-07-11
- 全網(wǎng)營銷推廣方案 2022-12-17