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

asked 15 Dec '22, 07:33

Martin's gravatar image

Martin
8.8k126162249
accept rate: 14%

1

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

(15 Dec '22, 07:49) Volker Barth
Replies hidden

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

(15 Dec '22, 08:37) Martin

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.

permanent link

answered 15 Dec '22, 08:33

Chris%20Keating's gravatar image

Chris Keating
6.9k43115
accept rate: 30%

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
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • 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:

×7

question asked: 15 Dec '22, 07:33

question was seen: 175 times

last updated: 16 Dec '22, 10:04