MySQL Forums
Forum List  »  MySQL Administrator

privileges - db creator getting ownership
Posted by: sdfg sdfg
Date: April 02, 2012 07:22AM

Hello everyone,

I got a question about the creator privileges on mysql.

I want to setup a mysql with multiple users and their own DBs. Up to this; no big deal. The problem is that i got a client that wants to create new databases on the fly. Si I thought about giving him the creator privilege thinking that he would get ownership on the DB he just created but he doesn't.

So I want to know if it is possible with mysql to give privileges so that a user can create and own his own DBs without having access to others' DBs?

Thanks for you time ;)

Edited 3 time(s). Last edit at 04/02/2012 07:25AM by sdfg sdfg.

Options: ReplyQuote

Written By
privileges - db creator getting ownership
April 02, 2012 07:22AM

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.