授予创建表的权限 - SQL Server [英] Grant Permission to CREATE tables - SQL Server

问题描述

授予用户创建(和删除)表权限的 SQL 命令是什么?我正在寻找类似的东西:

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

GRANT INSERT, UPDATE, SELECT ON Customers TO Joe

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

I have spent some time Googling for the answer.

推荐答案

当我用 google 搜索时，我有权访问 技术网.看起来你想要:

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

GRANT CREATE TABLE

如:

USE AdventureWorks2012;
GRANT CREATE TABLE TO MelanieK;
GO

这篇关于授予创建表的权限 - SQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！