Re: create a user for app admin

[mos]

At 08:56 AM 2/26/2010, Elim PDT wrote:
>Is there a way to create a user that has full control over a specified 
>database but cannot access any other database at all?
>that user cannot delete the specified database, cannot create/delete other 
>database, but can do everything within the specified database?
>
>Thanks for any help.

After reading the manual on Grant, download SqlYog community edition. It 
has a GUI that sets up user rights.

http://code.google.com/p/sqlyog/

Mike