How Can I Resolve "CREATE TABLE permission denied" error in SQL Server?
S
Stéphanie FOURRIER
started a topic
over 4 years ago
How Can I Resolve "CREATE TABLE permission denied" error in SQL Server?
Best Answer
S
Stéphanie FOURRIER
said
over 4 years ago
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.
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_ownerrole membership, then click OK and re-attempt the operation.
1 Comment
S
Stéphanie FOURRIER
said
over 4 years ago
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.
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_ownerrole membership, then click OK and re-attempt the operation.
Stéphanie FOURRIER
How Can I Resolve "CREATE TABLE permission denied" error in SQL Server?
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.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_ownerrole membership, then click OK and re-attempt the operation.Stéphanie FOURRIER
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.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_ownerrole membership, then click OK and re-attempt the operation.