35   sqlite3 *db,  in sqlite3UserAuthPrepare()  argument
43   u64 savedFlags = db->flags;  in sqlite3UserAuthPrepare()
49   db->flags |= SQLITE_WriteSchema;  in sqlite3UserAuthPrepare()
50   rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0);  in sqlite3UserAuthPrepare()
51   db->flags = savedFlags;  in sqlite3UserAuthPrepare()
63 static int userTableExists(sqlite3 *db, const char *zDb){  in userTableExists()  argument
65   sqlite3_mutex_enter(db->mutex);  in userTableExists()
66   sqlite3BtreeEnterAll(db);  in userTableExists()
67   if( db->init.busy==0 ){  in userTableExists()
69     sqlite3Init(db, &zErr);  in userTableExists()
70     sqlite3DbFree(db, zErr);  in userTableExists()
72   rc = sqlite3FindTable(db, "sqlite_user", zDb)!=0;  in userTableExists()
73   sqlite3BtreeLeaveAll(db);  in userTableExists()
74   sqlite3_mutex_leave(db->mutex);  in userTableExists()
85   sqlite3 *db,               /* The database connection to check */  in userAuthCheckLogin()  argument
93   if( !userTableExists(db, "main") ){  in userAuthCheckLogin()
97   if( db->auth.zAuthUser==0 ){  in userAuthCheckLogin()
101   pStmt = sqlite3UserAuthPrepare(db,  in userAuthCheckLogin()
105   sqlite3_bind_blob(pStmt, 1, db->auth.zAuthPW, db->auth.nAuthPW,SQLITE_STATIC);  in userAuthCheckLogin()
106   sqlite3_bind_text(pStmt, 2, db->auth.zAuthUser, -1, SQLITE_STATIC);  in userAuthCheckLogin()
116   sqlite3 *db,               /* The database connection to check */  in sqlite3UserAuthCheckLogin()  argument
124   savedAuthLevel = db->auth.authLevel;  in sqlite3UserAuthCheckLogin()
125   db->auth.authLevel = UAUTH_Admin;  in sqlite3UserAuthCheckLogin()
126   rc = userAuthCheckLogin(db, zDb, peAuth);  in sqlite3UserAuthCheckLogin()
127   db->auth.authLevel = savedAuthLevel;  in sqlite3UserAuthCheckLogin()
135 void sqlite3UserAuthInit(sqlite3 *db){  in sqlite3UserAuthInit()  argument
136   if( db->auth.authLevel==UAUTH_Unknown ){  in sqlite3UserAuthInit()
138     sqlite3UserAuthCheckLogin(db, "main", &authLevel);  in sqlite3UserAuthInit()
139     db->auth.authLevel = authLevel;  in sqlite3UserAuthInit()
140     if( authLevel<UAUTH_Admin ) db->flags &= ~SQLITE_WriteSchema;  in sqlite3UserAuthInit()
194   sqlite3 *db,           /* The database connection */  in sqlite3_user_authenticate()  argument
201   db->auth.authLevel = UAUTH_Unknown;  in sqlite3_user_authenticate()
202   sqlite3_free(db->auth.zAuthUser);  in sqlite3_user_authenticate()
203   sqlite3_free(db->auth.zAuthPW);  in sqlite3_user_authenticate()
204   memset(&db->auth, 0, sizeof(db->auth));  in sqlite3_user_authenticate()
205   db->auth.zAuthUser = sqlite3_mprintf("%s", zUsername);  in sqlite3_user_authenticate()
206   if( db->auth.zAuthUser==0 ) return SQLITE_NOMEM;  in sqlite3_user_authenticate()
207   db->auth.zAuthPW = sqlite3_malloc( nPW+1 );  in sqlite3_user_authenticate()
208   if( db->auth.zAuthPW==0 ) return SQLITE_NOMEM;  in sqlite3_user_authenticate()
209   memcpy(db->auth.zAuthPW,zPW,nPW);  in sqlite3_user_authenticate()
210   db->auth.nAuthPW = nPW;  in sqlite3_user_authenticate()
211   rc = sqlite3UserAuthCheckLogin(db, "main", &authLevel);  in sqlite3_user_authenticate()
212   db->auth.authLevel = authLevel;  in sqlite3_user_authenticate()
213   sqlite3ExpirePreparedStatements(db, 0);  in sqlite3_user_authenticate()
234   sqlite3 *db,           /* Database connection */  in sqlite3_user_add()  argument
242   sqlite3UserAuthInit(db);  in sqlite3_user_add()
243   if( db->auth.authLevel<UAUTH_Admin ) return SQLITE_AUTH;  in sqlite3_user_add()
244   if( !userTableExists(db, "main") ){  in sqlite3_user_add()
246     pStmt = sqlite3UserAuthPrepare(db,   in sqlite3_user_add()
257   pStmt = sqlite3UserAuthPrepare(db,   in sqlite3_user_add()
266   if( db->auth.zAuthUser==0 ){  in sqlite3_user_add()
268     sqlite3_user_authenticate(db, zUsername, aPW, nPW);  in sqlite3_user_add()
281   sqlite3 *db,           /* Database connection */  in sqlite3_user_change()  argument
291   authLevel = db->auth.authLevel;  in sqlite3_user_change()
296   if( strcmp(db->auth.zAuthUser, zUsername)!=0 ){  in sqlite3_user_change()
297     if( db->auth.authLevel<UAUTH_Admin ){  in sqlite3_user_change()
305   db->auth.authLevel = UAUTH_Admin;  in sqlite3_user_change()
306   if( !userTableExists(db, "main") ){  in sqlite3_user_change()
309     pStmt = sqlite3UserAuthPrepare(db,  in sqlite3_user_change()
320   db->auth.authLevel = authLevel;  in sqlite3_user_change()
332   sqlite3 *db,           /* Database connection */  in sqlite3_user_delete()  argument
336   if( db->auth.authLevel<UAUTH_Admin ){  in sqlite3_user_delete()
340   if( strcmp(db->auth.zAuthUser, zUsername)==0 ){  in sqlite3_user_delete()
344   if( !userTableExists(db, "main") ){  in sqlite3_user_delete()
348   pStmt = sqlite3UserAuthPrepare(db,  in sqlite3_user_delete()