CODEWITHSUNDEEP
sqlsql-server
w0051977
w0051977

Reputation: 15787

Grant Permission to CREATE tables - SQL Server

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.

Upvotes: 40

Views: 148713

Answers (2)

Karl Kieninger
Karl Kieninger

Reputation: 9129

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

GRANT CREATE TABLE

As in:

USE AdventureWorks2012;
GRANT CREATE TABLE TO MelanieK;
GO

Upvotes: 51

Eelco Drost
Eelco Drost

Reputation: 415

Two Options

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

Upvotes: 26

Related Questions