授予创建表的权限 - SQL Server

Grant Permission to CREATE tables - SQL Server

提问by w0051977

What is the SQL command for giving a user permissions to create (and delete) tables? I am looking for something similar to this:

授予用户创建（和删除）表权限的 SQL 命令是什么？我正在寻找类似的东西：

GRANT INSERT, UPDATE, SELECT ON Customers TO Joe

I have spent some time Googling for the answer.

我花了一些时间在谷歌上搜索答案。

回答by Karl Kieninger

When I googled, I got right to TechNet. It looks like you want:

当我用谷歌搜索时，我直接访问了TechNet。看起来你想要：

GRANT CREATE TABLE

As in:

如：

USE AdventureWorks2012;
GRANT CREATE TABLE TO MelanieK;
GO

回答by Eelco Drost

Two Options

两种选择

1. GRANT CREATE TABLE TO Joe AS dbo
2. Add the user to the fixed database role: db_ddladmin

1. GRANT CREATE TABLE TO Joe AS dbo
2. 将用户添加到固定数据库角色： db_ddladmin