Create and Alter Table Permission only for specific schema

  • Hello experts,

    I need advice on how to grant create table, alter table and create procedure permissions on a specific schema to a specific user.

    I set the user to be the schema owner and thought this would suffice - but it doesn't.

    Thanks in advance,


  • Explicitly grant permissions on the schema, for example:

    GRANT EXECUTE ON SCHEMA::myschema TO myroleoruser;

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • I'll give it a try on monday, thank you Jeffrey.


  • Hi;

    I want to grant privileges in sql server 2005 to a db user to create and alter tables.

    can anyone helpe me on this.


  • Grant create table to username

    Grant alter to username

  • Jeffrey Williams 3188 - Friday, July 9, 2010 1:47 PM

    Explicitly grant permissions on the schema, for example:GRANT EXECUTE ON SCHEMA::myschema TO myroleoruser;

    "GRANT CREATE TABLE ON SCHEMA::."... is not valid.

  • ejoell 66477 - Wednesday, September 28, 2011 2:22 PM

    Grant create table to usernameGrant alter to username

    GRANT Perpetual Headaches to DBA

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply