Open a database which needs user and password, for example MySQL/MariaDB or PostgreSQL. Open pane tables. You will be asked for username and password. Connection has been established. Now close the Base file, not the whole LO. Open any other document and reopen the Base file. Open pane table. You aren't asked for username and password any more. The connection to the database will only be closed when whole LO has been closed. Think this is a security problem. There must be a possibility to set "close connection when closing Base file". This behavior appears in LO 7.3.3.1 and all other versions of LO I have installed, oldest version here is LO 6.1.5.2 on OpenSUSE 15.3 64bit rpm Linux. Could be it is inherited by OOo.
Created attachment 179729 [details] Spreadsheet with password "password"
Created attachment 179730 [details] Database document connected to password.password.ods in same folder
Also reproducible with a connection to a password protected spreadsheet. Put both attachments in same folder. Open the odb, click "Tables", enter password "password". Name does not matter. The table "Sheet1" becomes accessible. Close the odb. Reopen the odb. Click "Tables". "Sheet1" is accessible with no password prompt until you shut down the office.
Confirming the behavior exits with: Version: 7.5.3.2 (X86_64) Build ID: 50(Build:2) CPU threads: 1; OS: Linux 6.3; UI render: default; VCL: kf5 (cairo+xcb) Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded and Version: 7.7.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 5a2c6f4df7149f8c1f543f120fe19bd66abfc189 CPU threads: 1; OS: Linux 6.3; UI render: default; VCL: kf5 (cairo+xcb) Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded Not sure if this is the desired behavior or not, maybe someone with more experience can chime in?
Depending on commet3 and comment4 I will set this one to NEW.