表一字段update权限

千家信息网最后更新 2024年11月20日表一字段update权限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.