Page 1 of 1

Privileges question

Posted: Fri Mar 28, 2008 6:21 pm
by dhampson
My program will have several users, but I only want the "administrator" account to be able to change user's passwords. However, I don't want the "administrator" to have access to everything (ala root). What are the minimum global privileges needed for this account to be able to set/modify user's passwords?

Thanks

--Dave

Re: Privileges question

Posted: Fri Mar 28, 2008 6:57 pm
by Christopher
Do you mean passwords in the OS, for your database, or your application?

Re: Privileges question

Posted: Sat Mar 29, 2008 7:52 pm
by dhampson
I'm referring to mysql privileges. "CREATE USER" is one thing I granted this account, but was unable to drop a client with just this privilege. I also gave it "GRANT" privileges, but that didn't allow the ability to drop users. I ended up giving a TON of privileges, but it makes me a little nervous to have done so.

Hense, the question about the minimum mysql privileges needed to add/drop users.

--Dave