On Tue, Feb 15, 2005 at 08:21:10AM -0800, teoh wrote: > hi , Is it possible to prompt user for username and > password before allow to use database like in mysql?
An SQLite database is a single disk file. If you can grab the file, you can use the 'sqlite' shell or your own SQLite API-using program to look at it. If you use SQLite with PHP, say, you can use some external authentication mechanism (backed by another SQLite database, even) to control access to your SQLite database file. In this case, the 'user' accessing the SQLite database(s) is the Apache server process in the typical mod_php situation. My company (ahem, the company I work for) sells an encrypting version of SQLite where the encryption key is derived from a passphrase. But there is still no notion of 'user'. HTH. -- Ng Pheng Siong <[EMAIL PROTECTED]> http://sandbox.rulemaker.net/ngps -+- M2Crypto, ZServerSSL for Zope, Blog http://www.sqlcrypt.com -+- Database Engine with Transparent AES Encryption
