Print Thread
Data change despite Read-Only Connection
#62970 01/31/22 04:48 PM
Joined: Dec 2001
Posts: 236
berlin
F
fraenkg Offline OP
Member
OP Offline
Member
F
Joined: Dec 2001
Posts: 236
berlin
"You can now define connections as read-only, so that you cannot make any modifications to the table data or object definitions. Any attempt to make such a modification will lead to an error message"
This works very well for normal DDL and DML calls.
But beware if a function with the pragma 'autonomous_transaction' is called from a query, data changes can very well occur!

Re: Data change despite Read-Only Connection
fraenkg #62984 02/01/22 10:16 AM
Joined: Aug 1999
Posts: 22,200
Member
Offline
Member
Joined: Aug 1999
Posts: 22,200
Function and procedure calls can indeed still modify the database.


Marco Kalter
Allround Automations

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.031s Queries: 15 (0.009s) Memory: 2.4946 MB (Peak: 3.0378 MB) Data Comp: Off Server Time: 2024-04-20 08:43:26 UTC
Valid HTML 5 and Valid CSS