Home Forums SQL Server 2005 SQL Server 2005 Security Create table permission denied RE: Create table permission denied

  • November 25, 2009 at 10:57 pm

    #1084452

    Make the person a member of ddl_admin, or grant them CREATE TABLE rights in the database and ALTER rights on the schema.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass