HiveBrain v1.2.0
Get Started
← Back to all entries
snippetsqlMinor

Can't create table in database with db_owner role (SQL Server 2012)

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
can2012createwithdb_ownersqldatabaseroleservertable

Problem

I have database in SQL Server 2012 SP2 Enterprise. I created new SQL Login and mapped to X database with db_owner role. Now I can't create table on this database. When I run simple create table script I got below error.


Msg 262, Level 14, State 1, Line 1

CREATE TABLE permission denied in database 'INVENTORY_TEST'.

There is no database or server trigger. I did not find any SQL Server bug related to this problem. Any idea?

Solution

The problem solved. In the Database options - Permissions tab public Database role was added and it was Deny permission for Create database option. After I removed Deny permissions it is OK now. User can create table.

Context

StackExchange Database Administrators Q#82213, answer score: 2

Revisions (0)

No revisions yet.