I was able to add the
dbcreator server role to a user of a SQL Server DB, thanks to this nice question/answer: create-database-permission
How can I REMOVE that permission? Is there a stored procedure like
sp_addsrvrolemember that works on the contrary and that I can use to drop that permission for the same user for which I granted it?
I tried using
sp_droprolemember, but i got a "dbcreator is not a role" error message.
I need to do it programmatically.
Many thanks in advance!
(Sorry if a similar question was already asked, but I was not able to find it)