I believe I recall a comment from Richard quite some time ago that this extension is no longer maintained. It did work as you think it should work, once upon a time. Apparently that is no longer the case. In any case, any such "thing" could be bypassed by simply using a version of SQLite that does not have that code installed, so it is not of much value. That is, the most appropriate description is that it would provide "authentication theater", and not actual meaningful authentication.