Ryan,
Thursday, November 28, 2002, 9:56:00 PM, you wrote:

RM> Please pardon my extreme case of the NEWBs on this but I need some help please.
RM> Ok I just purchased a book to hopefully clear things up for me, but to no
RM> avail. So this is my dilemma: I want to know about MySQL administration,
RM> specifically the user management portion of the admining. I want to be able to
RM> allow users to create whatever DBs they need. One DB for my Multi-media
RM> collection, one for an address book, one DB for links for a web site. Whatever
RM> the case may be! But it seems like I can't give a user the option to create
RM> and/or delete any DBs that only user X made. So I the admin would have to
RM> create each DB and assign appropriate privileges to appropriate users?

RM> So to sum up my situation into a question: Is it possible for me to give a user
RM> the ability to create and/or delete only their DBs?

Only with MySQL - nope.

RM> Or do I have to make the DB
RM> for them and then Grant appropriate privileges for that user to that DB?

It's much easier..




-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com




---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to