Sorry about the title of the post, but I didn't quite know how to explain this. Here's my issue.
I have a SQL Server that I manage. It is in an Active Directory domain and since I'm the domain admin, I have full rights to it.
I would like to "lock down" the server so that other users can create databases, but cannot have access to mine.
Currently, the other users are using a username that has the same rights as SA. The SA account is scheduled for disabling by the end of the year.
Of course they have become very used to creating there own databases and users without any help from me. I would like to lower there rights so that they can keep using there databases and create any usernames that they would need, but would no longer have the rights of the SA account.
Any ideas? Thanks in advance.