Thread
:
sqlite question
View Single Post
briand
2008-03-06 , 20:10
Posts: 566 | Thanked: 145 times | Joined on Feb 2008 @ Tallahassee, FL
#
3
you don't have permission,
within the database
, to update, add, and/or modify. I've not played with SQLITE, so the exact syntax may not be the same (in other words, hit the documentation and read... don't just blindly type this!!), but if you log in as the database administrator account (which should have access to everything), you can grant rights to the other account(s) in the database.
GRANT ALL ON <database> TO <username> IDENTIFIED BY <password> WITH GRANT OPTION;
The username/password is the
database
username and password, not (necessarily) the
system
username and password!
Quote & Reply
|
briand
View Public Profile
Send a private message to briand
Visit briand's homepage!
Find all posts by briand