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.
Launch SQL Server Management Studio and connect with credentials that have been granted the 'sa' role. Expand Security, right-click on Logins and select New Login. Enter a descriptive Login name, select SQL Server authentication, and enter a secure password.
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
Two Options
GRANT CREATE TABLE TO Joe AS dbo
db_ddladmin
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With