Create table permission in particular schema

• ramana3327

  SSCoach

  Points: 19722

  More actions

  February 2, 2016 at 11:13 pm

  #323998

  Hi,

  How to give a user to create table permission in a particular schema?

  I tested by giving execute permission to the user on the schema and it didn't work

  I tested by giving control/Alter permission to the user on the schema it is working but able to drop the table, which doesn't want

  Any other way to achieve this?

• sqlquaker

  Say Hey Kid

  Points: 697

  More actions

  February 3, 2016 at 7:05 am

  #1856273

  You may need to use a specific Database Role for this requirement.

  It could be worth trying this option suggested by Roi Gavish: http://dba.stackexchange.com/questions/21733/allow-user-to-do-anything-within-his-own-schema-but-not-create-or-drop-the-schem

  I haven't tested it myself. Please let us know if it helps.

  -Regards

• johnwalker10

  SSCrazy Eights

  Points: 9124

  More actions

  February 3, 2016 at 9:54 pm

  #1856452

  GRANT CREATE TABLE TO UserName

  GRANT ALTER ON SCHEMA::AllowedSchema TO UserName

  DENY ALTER ON SCHEMA::RestrictedSchema TO UserName