Post reply

full permission for a table

  • May 6, 2015 at 1:14 pm

    #297953

    i need to set permission like full control, insert, update, delete etc .

    so the user can drop index and recreate and truncate data from a table.

    can someone provide a script for this ?

  • May 6, 2015 at 1:48 pm

    #1796058

    GRANT SELECT, UPDATE, INSERT, DELETE, ALTER ON [schema].[tablename] TO [username];

  • May 6, 2015 at 5:22 pm

    #1796083

    thanks.

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

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