oracle更新字段权限,表一字段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.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7569309/viewspace-2146788/，如需转载，请注明出处，否则将追究法律责任。