Re: [sqlite] sqlite login password

[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  wrote:

>
> On 4 Jan 2015, at 1:00am, Richard Hipp  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

Re: [sqlite] sqlite login password

[Simon Slavin]

On 4 Jan 2015, at 1:00am, Richard Hipp  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

[Richard Hipp]

On Sat, Jan 3, 2015 at 7:59 PM, Simon Slavin  wrote:

>
> On 4 Jan 2015, at 12:56am, YAN HONG YE  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

[Simon Slavin]

On 4 Jan 2015, at 12:56am, YAN HONG YE  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