I have a php/mysql based website that offers several things, one of which is an online journal. Right now, members have the option of writing public and private journal entries (every user has a mysql table dedicated to their entries), but I have no way of guaranteeing that any private entries are completely inaccessible to me.
Not knowing a great deal about user priviledges, is it possible to create a set of tables/databases that would be accessible to the user only (while keeping the root priviledges for everything else intact)?
I'd like to be able to tell members that yes, with the password they entered, only they can get to the table containing their private entries, and no one else, specifically the admin (me).
thanks in advance~
-michael
Not knowing a great deal about user priviledges, is it possible to create a set of tables/databases that would be accessible to the user only (while keeping the root priviledges for everything else intact)?
I'd like to be able to tell members that yes, with the password they entered, only they can get to the table containing their private entries, and no one else, specifically the admin (me).
thanks in advance~
-michael