title: CREATE TABLE permission denied in database SQL Server 2008 R2 ApsaraDB for RDS
body: <p>After I created a new Database 'testDB' . 
  Using SSMS 2012 I'm getting an error </p>
  
  <pre><code>CREATE TABLE permission denied in database 'testDB'
  </code></pre>
  
  <p>This is My Code </p>
  
  <pre><code>USE [testDB]
  GO
  
  SET ANSI_NULLS ON
  SET QUOTED_IDENTIFIER ON
  GO
  
  CREATE TABLE [dbo].[Employeetempp]
  ([FirstName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
   [LastName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
  ) ON [PRIMARY]
  </code></pre>
  
  <p>And Also adding My Permissions For the DB</p>
  
  <pre><code>CREATE VIEW
  CREATE PROCEDURE
  CREATE FUNCTION
  CREATE RULE
  CREATE DEFAULT
  CREATE TYPE
  CREATE XML SCHEMA COLLECTION
  CREATE SCHEMA
  CREATE SYNONYM
  CREATE AGGREGATE
  CREATE QUEUE
  CREATE FULLTEXT CATALOG
  CONNECT
  CONNECT REPLICATION
  CHECKPOINT
  SUBSCRIBE QUERY NOTIFICATIONS
  AUTHENTICATE
  SHOWPLAN
  ALTER ANY SCHEMA
  ALTER ANY FULLTEXT CATALOG
  SELECT
  REFERENCES
  EXECUTE
  VIEW DATABASE STATE
  VIEW DEFINITION
  ALTER
  CONTROL
  </code></pre>
  
  <p>What can I  do to to obtain permission for creating the table. </p>
  
  <p>I went into the database, security, users, right-click on the user, properties. Membership The 'db_owner' property is checked. </p>
  
  <p>Thanks ,
  Nidhin </p>