> Hi !
> I have a little problem on my Linux 5.2, I use mysql-3.21.30 and php-3.0.5.
> I made a webboard on my homepage, which is included a function of modifying
> their personal record on web, it's very working in web and shell as NOBODY account.
> NOBODY's privileges of user table is all 'N' and that of db table is
> Select_priv,Insert_priv, Update_priv are 'Y' and the others is 'N'.
> I made the password field of the writer in webboard database,
> therefore there is no problem in web.
> But, when they connect remote shell, he can modify others' records, not only his.
> It's problem.
> I'm afraid that some writer's article is to be modified by others. I want that they
> modify his,her own records on only Web but can't do it(including others' records) on
> Any solutions ?
> Thank you in advance.
You only can seperate the data per user in different tables.
But I think you need 3.22.14 or newer.
This is, because you only can specify priviledges on a table basis with this versions.
The other option is, to give access to this database only through webforms or another