Post reply

permission

  • May 6, 2012 at 11:45 pm

    #260522

    Can any one tell me

    HOw to grant only CREATE TABLE rights for the particular user .

    Many Thanks.

  • May 7, 2012 at 1:12 am

    #1483976

    USE AdventureWorks;

    GRANT CREATE TABLE TO MelanieK;

    GO

  • May 8, 2012 at 3:49 pm

    #1484801

    It is advisable to create a Database ROLE, add the USER to the ROLE, and GRANT the permission to the ROLE. Try to avoid granting permissions directly to Users wherever possible.

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

Viewing 3 posts - 1 through 2 (of 2 total)

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