I am looking to duplicate the MS SQL setup where I can grant someone permissions ... here can create databases rather than just tables under the mysql database. Is this right?< ...

Most SQL Server databases have a number of users viewing ... by double-clicking it in the Enterprise Manager’s right pane. The Permissions button will now be enabled. Click the Permissions ...

I'm wondering if there is a way for someone to be able to do maintenance work on a sql server without actually being able to look at the data. What kind of permissions would need to be set for that?< ...

it was difficult to allow users to see the SQL Server Agent jobs on your database server without giving the user sysadmin permissions. SQL Server 2005 makes assigning this permission much easier ...