Under the Scott user set read-only transactions is that,
But under the sys user set read-only transactions not make,
Set the read-only transactions under the sys user, under the Scott user can still modify tables and
CodePudding user response:
Say your experimental process,CodePudding user response:
Up sqlplus opened two Windows, one is Scott, a sys as sysdba,Under the Scott user set read-only transactions, normal;
Under the sys user set read-only transactions, cannot reflect the read-only role;
Under the sys user set read-only transactions in Scott operation, cannot reflect the read-only role;
Under the Scott user:
On a table named emp2 operation:
The delete from emp2 where deptno='10';
Commit;
Then test read-only transactions:
Set the transaction read only;
The delete from emp2 where deptno='10';
Prompt to;
Under the sys user:
Sys> The set transation read only;
Sys> The delete from emp2 where deptno='10';
Delete the success;
Under the Scott user, the sys user:
Sys> The set transation read only;
Scott> The delete from emp2 where deptno='10';
Scott> Commit;
Sys> Select * from emp2;
The results for the deptno=10 rows are deleted,
So my question is, does the read-only permissions only effective for ordinary users, for the sys is invalid,
CodePudding user response:
Has solved, it is effective for ordinary users, the sys is invalid