Shulou(Shulou.com)06/01 Report--

1. Create an environment

SQL > create user ltest identified by ltest

User created.

SQL > grant connect,resource to ltest

Grant succeeded.

two。 Attempt to update

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. Empowering

SQL > grant select,update (object_id) on system.test to ltest

Grant succeeded.

4. Attempt to update

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.