SQL Rights Creator/Owner

Question

Our software has data to store, so it also install MYSQL, a root user and a user with read only access if a third party compagny wants to install a backup solution for our data. But the third party wants to write data (a timestamp for backup purpose or something like that...) to another database. How can I change the user so it has read only acces to our database and creator/owner rights to other databases.

Second part of my question : we migth switch to POSTGRES later. Does the creator/owner right (or the equivalent solution) exists in POSTGRES as well ?

Am I clear enough ?

Answer 1

you need to read this page from the mysql manual: http://dev.mysql.com/doc/refman/5.0/en/grant.html

this page describes how to grant permissions to existing and new users with the restrictions you have requested.

Answer 2

After a few searches I've found nothing that indicates that such a thing exists.