List:General Discussion« Previous MessageNext Message »
From:Olaf Stein Date:July 25 2007 12:05am
Subject:RE: su-like functionality
View as plain text  
In that case you either need the users password or create a user with the same permissions
and try with that user

Olaf


-----Original Message-----
From: Pete Harlan [mailto:harlan@stripped]
Sent: Tue 7/24/2007 7:30 PM
To: Mogens Melander
Cc: Carlo Sogono; mysql@stripped
Subject: Re: su-like functionality
 
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

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1



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