Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have user "U" who I want to give him full access to all the existing databases except "db1". I want him to only have select privilege for that db. What I did is I gave "U" all permissions for each db one by one and select permission on "db1". What I want to do is to give "U", the create database privilege and full access to any created database by him. Is there anyway that I could do it? I don't want to add privileges every time someone creates a db.

share|improve this question
Same as [this][1] on stackoverflow, some answers there [1]: stackoverflow.com/questions/2950054/… –  geermc4 Sep 18 '12 at 17:42
could you edit the "this"? its not a link. thanx –  AliBZ Sep 18 '12 at 17:44
Hmm, it was when i posted it as a answer but it converted to a comment, anyways the link was ment to point to that stackoverflow link at the end –  geermc4 Sep 18 '12 at 17:54

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.