MySQL Forums
Forum List  »  Security

Granting security
Posted by: Jonathan Nordell
Date: January 08, 2008 02:17PM

I have a user 'xyz' that has create_priv, reload_priv, grant_priv, and create_user_priv by default. That user 'xyz' then has specific database privileges defined for a another database 'xxx'. The user 'xyz' can create other databases and tables within those databases. What I need is for user 'xyz' to then be able to create other users with permissions to this new database. When I try this I'm getting an access denied messaged.

mysql> create database `yyy`;
Query OK, 1 row affected (0.00 sec)

mysql> use yyy
Database changed

mysql> CREATE TABLE `yyy`.`audit` (
`id` bigint(20) NOT NULL auto_increment,
`module` varchar(10) NOT NULL,
`login` varchar(75) NOT NULL default '',
`logged` int(10) NOT NULL,
`ip` varchar(25) NOT NULL default '',
`extrainfo` varchar(100) default NULL,
PRIMARY KEY (`id`),
KEY `login` (`login`),
KEY `logged` (`logged`),
KEY `module` (`module`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
Query OK, 0 rows affected (0.10 sec)

mysql> grant select, insert, update, delete on `yyy`.* to 'tempuser'@'localhost' identified by 'temppass';
ERROR 1044 (42000): Access denied for user 'xyz'@'localhost' to database 'yyy'

What permissions am I missing to allow user 'xyz' to create new users and grant privileges to that user?

Options: ReplyQuote


Subject
Views
Written By
Posted
Granting security
3971
January 08, 2008 02:17PM
2807
January 10, 2008 10:49AM


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.