From: Christian Mack
Date: March 22 1999 1:37pm
Subject: Re: Privilege on web and remote shell.
List-Archive: http://lists.mysql.com/mysql/765
Message-Id: <36F64781.69263AA5@compal.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

skims wrote:
> 
> 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 can
> modify his,her own records on only Web but can't do it(including others' records) on remote
> +shell.
> 
> Any solutions ?
> 
> Thank you in advance.
> 
> skims.

Hi Skims

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 client program.

Tschau
Christian