表一字段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.









文章标题:表一字段update权限
当前地址:http://myzitong.com/article/ihgipo.html