Start a new topic
Answered

How Can I Resolve "CREATE TABLE permission denied" error in SQL Server?

How Can I Resolve "CREATE TABLE permission denied" error in SQL Server?


Best Answer

When attempting to Create New Data Location(using SQL Server), the operation may instead fail with a CREATE TABLE permission denied in database 'X' error.

"CREATE TABLE permission denied in database 'X' " error.
"CREATE TABLE permission denied in database 'X' " error.

Using a client such as SQL Server Management Studio, connect to the database and open the properties for the connecting user account. Add the db_owner role membership, then click OK and re-attempt the operation.

1 Comment

Answer

When attempting to Create New Data Location(using SQL Server), the operation may instead fail with a CREATE TABLE permission denied in database 'X' error.

"CREATE TABLE permission denied in database 'X' " error.
"CREATE TABLE permission denied in database 'X' " error.

Using a client such as SQL Server Management Studio, connect to the database and open the properties for the connecting user account. Add the db_owner role membership, then click OK and re-attempt the operation.

Login to post a comment