How to get CREATE TABLE Permission for windows authentication users in SQL Server express 2005

Question

I recently installed SQL Server 2005 Management Studio Express. When I login to the Database server machinename\SQLEXPRESS using Windows Authentication.

I am unable to create tables or create databases. How do I grant the permissions for the users logged in as Windows Authentication to be able to create tables / databases?

score 2 · Accepted Answer · answered Apr 26 '11 at 08:45

2

You can make your user part of the sysadmin role

exec sp_addsrvrolemember 'DomainOrComputerName\UserName','sysadmin'

answered Apr 26 '11 at 08:45

Mikael Eriksson

136,425
22
210
281

score 2 · Answer 2 · answered May 18 '11 at 18:33

That will solve your problem but it is overkill and grants the users complete access to your database including the ability to delete your databases and technically they can do anything on your computer they want unless you have limited your SQL Server Service accounts rights. To allow the ability to create tables use

Grant Create Table to [domainName\userName] That will give them the ability to create a table in the database where you run that statement.

How to get CREATE TABLE Permission for windows authentication users in SQL Server express 2005

2 Answers2