List:General Discussion« Previous MessageNext Message »
From:Pete Harlan Date:July 24 2007 11:30pm
Subject:Re: su-like functionality
View as plain text  
On Tue, Jul 24, 2007 at 02:18:21AM +0200, Mogens Melander wrote:
> 
> On Mon, July 23, 2007 10:19, Carlo Sogono wrote:
> > Is there a way for mysql to login as an administrator and "su" to a
> > normal user?
> >
> > What I'd like to achieve is a way to log in to our clients' accounts (we
> > are a web-hosting company) without having to use their passwords. Having
> > to su keeps ownerships and stuff like that in check.
> >
> > Thanks in advance,
> > Carlo
> 
> ??? I'm having a hard time imagine what you want to do with that ???
> 
> You, being the administrator (root), you should be able to do whatever,
> on any DB on your server, without being recognzied as anybody.
> 
> Please elaborate.

It wasn't my question, but I imagine this would be useful when you
want to verify that you have set up their permissions correctly.

E.g., a user says, "I tried to do X but it wouldn't let me," and you
go in as them, repeat the problem behavior, fix it, test your fix, and
let them know it is fixed.

(Or, similarly, verify for yourself that their user is unable to do
things you don't want them to do.)

--Pete
Thread
su-like functionalityCarlo Sogono23 Jul
  • Re: su-like functionalityOlaf Stein23 Jul
  • Re: su-like functionalityMogens Melander24 Jul
    • Re: su-like functionalityCarlo Sogono24 Jul
      • Re: su-like functionalityMogens Melander24 Jul
    • Re: su-like functionalityPete Harlan25 Jul
  • RE: su-like functionalityOlaf Stein25 Jul