Posted by Tim on 06/02/06 18:23

Paul Lautman wrote:
> Tim wrote:
> > Bob Sanderson wrote:
> >> I have created a MySQL database for my company which is accessed by
> >> PHP pages. I would like to permit some users to edit the records but
> >> allow others read-only access. However, I don't want to have to
> >> enter a password every time I want to edit a record. Is there a way
> >> to use our network login to do this? If not, what is the easiest way
> >> to accomplish this? The database is running on our server and is not
> >> accessible via the net.
> >>
> >> Any help will be greatly appreciated.
> >
> > This is one way to do it
> >
> > In mysql use CREATE USER and GRANT to set up a user account with read
> > only permissions, you probably have a user account with full
> > permissions to use but you may want to setup another user account with
> > limited write permissions to give to others.
> >
> > In the php script call a system command to get the login name of the
> > current user. On *nix systems its 'whoami', on windows I think its
> > whoami.exe but don't quote me on that..
>
> But wouldn't the whoami run on the server, whilst the user is logged on to
> the client?

Yeah you're right, dont know what I was thinking. Ta

Tim

[Back to original message]