List:General Discussion« Previous MessageNext Message »
From:mos Date:February 26 2010 3:47pm
Subject:Re: create a user for app admin
View as plain text  
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 

Thread
create a user for app adminElim PDT26 Feb
  • Re: create a user for app adminJohan De Meersman26 Feb
  • Re: create a user for app adminmos26 Feb