表一字段update权限

发布时间：2020-08-13 04:32:36 阅读：196 作者：wanghao2979 栏目：关系型数据库

开发者测试专用服务器限时活动，0元免费领，库存有限，领完即止！点击查看>>

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.

亿速云「云服务器」，即开即用、新一代英特尔至强铂金CPU、三副本存储NVMe SSD云盘，价格低至29元/月。点击查看>>

向AI问一下细节

表一字段update权限

猜你喜欢

最新资讯

相关推荐

开发者交流群：

相关标签