adding user roles to phpLiteAdmin

Skip to first unread message

Míchael S.

May 4, 2021, 8:50:56 PM5/4/21
to phpliteadmin
Hello All.

I am in the middle of writing a PHP app which uses SQLite.  I got to thinking if my app ever needed a tech support person, how would I handle that?  Enter phpLiteAdmin.  Out of the box, phpLiteAdmin gives all access to any user that logs in successfully, and it does so amazingly.

There are, however, use cases for restricting what a logged-in user can do.  Think of "Roles" that exist in the MS world.

I've written code into the phpLiteAdmin script to do this.  Keeping with the simple password approach to gain access to phpLiteAdmin, and when a user is interested in these security arrangements, they simply create a 2nd, or 3rd (or...) password which would yield a different access level to phpLiteAdmin functions.

I envision this feature is implemented using a simple external configuration file specifically for these security purposes.  If the file isn't readable, then phpLiteAdmin would revert to working as it is now, with version

I'm interested in talking to the team in more detail!

Message has been deleted


Jul 21, 2021, 3:36:15 AM7/21/21
to phpliteadmin
Hi Michael

I'm also interested in this kind of feature! Something like allowing users to edit only certain tables inside my databse.
Let me know if you have any updates...


rafi farchi

Dec 28, 2021, 7:12:35 AM12/28/21
to phpliteadmin
Hi  Michael
I need exactly what you have done .
Can you please post it somewhere ?
Rafi farchi

Míchael S

Jan 1, 2022, 2:50:02 PMJan 1
to phpliteadmin
Hi Rafi, Chris, and anyone else:

I hope to have this added by mid-January 2022.


rafi farchi

Jan 10, 2022, 8:31:24 AMJan 10

When fo you think ne version with roles will br released ?

See a nice example of using 
Phpliteadmin .
It is vista medical system replicstion from mumps to sqlite .

Password :rafiafula

בתאריך שבת, 1 בינו׳ 2022, 21:50, מאת Míchael S ‏<>:
You received this message because you are subscribed to a topic in the Google Groups "phpliteadmin" group.
To unsubscribe from this topic, visit
To unsubscribe from this group and all its topics, send an email to
To view this discussion on the web visit
Reply all
Reply to author
0 new messages