can grant a login only create database with specific name?

Question

instead of create any database, can it be granted to only specific database name.

Answer 1

No. At least not directly. You could create a stored procedure that creates the database and grant execute to that user. Something like this.

USE master;
CREATE PROC CreateTestDB
WITH EXECUTE AS OWNER
AS
CREATE DATABASE TestDB;

GRANT EXECUTE ON CreateTestDB TO Barry;

EXECUTE AS USER = 'Barry';
EXEC CreateTestDB;
REVERT

---

Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty

Answer 2

thanks, great idea, though it some app vendors usually run their own program not able to use the procedure, but definitely this execute as proc can help in other cases.