Privileges question

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
dhampson
Forum Newbie
Posts: 19
Joined: Mon Mar 24, 2008 8:01 pm

Privileges question

Post 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
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Re: Privileges question

Post by Christopher »

Do you mean passwords in the OS, for your database, or your application?
(#10850)
dhampson
Forum Newbie
Posts: 19
Joined: Mon Mar 24, 2008 8:01 pm

Re: Privileges question

Post 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
Post Reply