Performs the update TB in user B B set b.n ame='bb' where b.i d=1 success, but in A
The user to perform the update B.t b b set b.n ame='bb' where b.i d=1, no success has been performed,
Have grant the select/update/alter on B.t b to A, this how to solve?

CodePudding user response:

Authorized command write wrong? GRANT, update, select ON the test TO dbuser;

CodePudding user response:

Check if authorized permission table success, user_tab_pr...

CodePudding user response:

B users update after the commit? Will not commit this record locking, leading to other updates have been waiting for

CodePudding user response:

An error message