Is alter user doing an auto-commit?

[MCMartin]

Is alter user to change the password doing an auto-commit or is a rollback of alter user possible?

[VolkerBarth]

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

[MCMartin]

Im wondering if it is missing from the docs or if my observation is wrong.

[chris_keating · Accepted solution]

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.

[jack_schueler · Accepted solution]

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.