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.-
xDM on Docker
-
Application Server Gives 404 Error
-
Change Prod Repository Type Without Reinstallation
-
Enable Access to Azure File Storage?
-
Why am I getting Status 404 -- Not Found Error on Azure?
-
Resolve "Unable to Create Work Directory" Error
-
What's the default font for Semarchy application?
-
Plain Text Password in Tomcat Config Files
-
How to resolve 'This stream is not writable' Tomcat error?
See all 16 topics