How to set up a database-administrator for one database only?

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

  • How to set up a database-administrator for one database only?

    Hello everyone!
    I am looking for a way to set up a special user who can create new users, but only grant them access to a single database.

    Let’s say we have ten databases working and we are adding new users every month.
    Now, for the database „DBPortugal“ I would like to set up a user that is able to
    -Create new users and
    -Add them to an existing goup with attached database-access-rights, while at the same time
    -He cannot give them access to another database.

    Hence, he is only able to administrate users/groups on his own database. I don’t want him to be able to grant access to the other databases.

    Any ideas? Thank you very much in advance!
    Olaf