[sqlite] sqlite login password

2015-01-03 Thread YAN HONG YE
I want to know how to setting a loging sqlite passwd?
When I input:
Sqlite mtdb
Command, the console will prompt like this:
Pls input your password:

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] sqlite login password

2015-01-03 Thread Simon Slavin

On 4 Jan 2015, at 12:56am, YAN HONG YE yanhong...@mpsa.com wrote:

 I want to know how to setting a loging sqlite passwd?
 When I input:
 Sqlite mtdb
 Command, the console will prompt like this:
 Pls input your password:

http://www.sqlite.org/src/doc/trunk/ext/userauth/user-auth.txt

It is only available in recent versions of SQLite.  Since 2014-10-17.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] sqlite login password

2015-01-03 Thread Richard Hipp
On Sat, Jan 3, 2015 at 7:59 PM, Simon Slavin slav...@bigfraud.org wrote:


 On 4 Jan 2015, at 12:56am, YAN HONG YE yanhong...@mpsa.com wrote:

  I want to know how to setting a loging sqlite passwd?
  When I input:
  Sqlite mtdb
  Command, the console will prompt like this:
  Pls input your password:

 http://www.sqlite.org/src/doc/trunk/ext/userauth/user-auth.txt

 It is only available in recent versions of SQLite.  Since 2014-10-17.


(1) The OP says he used the sqlite command (version 2 of SQLite) not
sqlite3.
(2) SQLite has *never* given a prompt Pls input your password.  That
message is coming from third-party software.



 Simon.
 ___
 sqlite-users mailing list
 sqlite-users@sqlite.org
 http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users




-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] sqlite login password

2015-01-03 Thread Simon Slavin

On 4 Jan 2015, at 1:00am, Richard Hipp d...@sqlite.org wrote:

 (1) The OP says he used the sqlite command (version 2 of SQLite) not
 sqlite3.
 (2) SQLite has *never* given a prompt Pls input your password.  That
 message is coming from third-party software.

I agree that my answer has nothing to do with the situation he described.  But 
it does answer the question he asked.  Our problem is that the situation he 
described could not have taken place.  Unless a third party wrote a utility 
they called 'Sqlite' which would, of course, be bad.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] sqlite login password

2015-01-03 Thread Stephen Chrzanowski
Maybe the question is How do I make SQLite do this when accessing a
database? and the 3 just got dropped inadvertently.  If that is the case,
as Dr. Hipp said, SQLite has never done it, and I'll add on that it has
never done it stock.

On the other hand, that link you posted, Dr. Hipp, is rather interesting.
Albeit limited functionality (I'd prefer a permissions type system for each
user instead of R/O access or full access) as the philosophy of SQLite is
to keep it slim, this basic authentication system might be what the OP is
running into.


On Sat, Jan 3, 2015 at 8:07 PM, Simon Slavin slav...@bigfraud.org wrote:


 On 4 Jan 2015, at 1:00am, Richard Hipp d...@sqlite.org wrote:

  (1) The OP says he used the sqlite command (version 2 of SQLite) not
  sqlite3.
  (2) SQLite has *never* given a prompt Pls input your password.  That
  message is coming from third-party software.

 I agree that my answer has nothing to do with the situation he described.
 But it does answer the question he asked.  Our problem is that the
 situation he described could not have taken place.  Unless a third party
 wrote a utility they called 'Sqlite' which would, of course, be bad.

 Simon.
 ___
 sqlite-users mailing list
 sqlite-users@sqlite.org
 http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users