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.賦權(quán)


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.









分享標(biāo)題：表一字段update權(quán)限
網(wǎng)頁(yè)地址：http://weahome.cn/article/ihgipo.html