|
CREATE USER and ALTER USER have an automatic commit side effect. DDL statements have automatic commit side effect (there may be exceptions, but I cannot think of any). The SAP based Help has been updated to indicate that CREATE USER has an automatic commit but the same was not done for ALTER USER. I have reported that documentation issue. 1
I believe that there is also a side affect on server-side connection pooling, in that the cache is cleared when ALTER USER is executed.
(16 Dec '22, 09:59)
JBSchueler
|
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- numbered list: 1. Foo 2. Bar
- to add a line break simply add two spaces to where you would like the new line to be.
- basic HTML tags are also supported
Question tags:
question asked: 15 Dec '22, 07:33
question was seen: 228 times
last updated: 16 Dec '22, 10:04
As to the docs, no (as you surely have found out yourself), whereas the similar GRANT CONNECT and CREATE USER are told to do so.
But this should be easy to test.
And just in case: You can do point-in-time-recovery with v17, so possibly to recover all operations until an undesired committed password change...
Im wondering if it is missing from the docs or if my observation is wrong.