MySQL Forums
Forum List  »  MySQL Administrator

Create_user_priv of "N" doesn't "disable" create user command
Posted by: Steve Shell
Date: January 13, 2010 12:42PM

(Using 5.1.41)

I have created a "DBA" user account for certain account commands, but I don't want the DBA account to create new user accounts. Only my "root" account on localhost is authorized to do that. However, in the mysql.user table the Create_user_priv is marked "N" but my DBA account can still do "create user 'foo'". I have the "Grant_priv" "Y" because the DBA account does specific grant to an existing user account.

Why is the create user command succeeding, and how can I disable it? Below are the Y/N columns for the mysql.user table for my DBA user, if that is helpful.

'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'Y', 'Y', 'Y', 'N', 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'Y',

Options: ReplyQuote

Written By
Create_user_priv of "N" doesn't "disable" create user command
January 13, 2010 12:42PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.