Post reply

Grant user "drop table" permission?

  • January 14, 2014 at 11:55 am

    #284447

    I tried running "Grant drop table to user" thinking it would work the same as create table permission. Well not!! I would like to grant a drop any table permission to a user that will be dropping randomnly generated table names. What permission is this?

    Thanks!

  • January 14, 2014 at 12:03 pm

    #1680021

    for a specific table, it's the ALTER permission; that obviously means they can add/drop columns as part of the table as well.

    GRANT ALTER TABLE on dbo.TableName to MyUser

    i belive if you created a table, since you are the owner, you can drop it as well. but tables created by other users would be off limits without additional permissions like above.

    if you want to grant to all tables, you'll probably end up giving the user the built in role db_ddlAdmin

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

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

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