• na1774 (9/8/2012)


    Hi All,

    The issue is I have to give permisions to a user just to create objects in only one schema and deny creations in other schemas.

    I am a little confused here. If I give a database scoped permission to create table then the user will be able to create tables in all the schemas.

    I was planning to give a exculsive deny create on all the schemas other than the schema in which user can create the tables.

    But there is no schema scoped permission to deany table creation.

    Can any one help me acheive this goal?

    In other words, your assertion above (bolded added) is incorrect.

    USE [YourDatabase];

    GRANT CREATE TABLE TO [YourUser];

    GRANT ALTER ON SCHEMA::[YourSchema] TO [YourUser];

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato