Can multiple passwords coexist?😂

[maxbad]

Login with different passwords can successfully see the data😁🤞

[utelle]

If you are talking about the SQLite User Authentication extension, then the answer to your question is yes. However, please note that this extension is about user authentication, not database encryption. For its use please consult its documentation.

SQLite3 Multiple Ciphers includes the SQLite User Authentication extension as well as several other extensions, which are enabled by default in the build files coming with SQLite3 Multiple Ciphers, but can be disabled by removing the corresponding preprocessor symbol.

The main feature of SQLite3 Multiple Ciphers is the support of several database encryption schemes. If database encryption is activated, then you have a single passphrase protecting the database. All users knowing this single passphrase can access the database.

Of course, it is possible to combine database encryption and user authentication. The process how to open a database in this case is described in the SQLite User Authentication documentation.

[utelle]

Closing ... because I think this is a non-issue. It's simply a matter of correctly using the various features offered by SQLite3 Multiple Ciphers.

I converted the issue into a discussion. Maybe others find the given information useful.