SQLite Forum

Does table have rowid?
Login
It is an information leakage expose, is my understanding.

Also, open a big database and execute `select * from pragma_integrity_check`.

Do you want someone to give you a database that has a view that selects from pragma_integrity_check?  Not setting the INNOCUOUS flag means that statements which execute pragmas must originate from your application (or have been put in the per connection temp table by your application) and cannot be put there by an external attacker.